Changes between Version 1 and Version 2 of LogicalAndPhysicalDesign
- Timestamp:
- 12/07/25 23:10:34 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
LogicalAndPhysicalDesign
v1 v2 3 3 {{{ 4 4 5 CREATE TABLE "User"(5 CREATE TABLE User ( 6 6 user_id BIGSERIAL PRIMARY KEY, 7 7 username VARCHAR(50) NOT NULL UNIQUE, … … 15 15 16 16 17 CREATE TABLE "VetClinic"(17 CREATE TABLE VetClinic ( 18 18 clinic_id BIGSERIAL PRIMARY KEY, 19 19 name VARCHAR(100) NOT NULL, … … 25 25 ); 26 26 27 CREATE TABLE "Animal"(27 CREATE TABLE Animal ( 28 28 animal_id BIGSERIAL PRIMARY KEY, 29 29 owner_id BIGINT NOT NULL, … … 43 43 44 44 45 CREATE TABLE "Listing"(45 CREATE TABLE Listing ( 46 46 listing_id BIGSERIAL PRIMARY KEY, 47 47 user_id BIGINT NOT NULL, … … 61 61 ); 62 62 63 CREATE TABLE "Appointment"(63 CREATE TABLE Appointment ( 64 64 appointment_id BIGSERIAL PRIMARY KEY, 65 65 animal_id BIGINT NOT NULL, … … 79 79 80 80 81 CREATE TABLE "HealthRecord"(81 CREATE TABLE HealthRecord ( 82 82 healthrecord_id BIGSERIAL PRIMARY KEY, 83 83 animal_id BIGINT NOT NULL, … … 101 101 ); 102 102 103 CREATE TABLE "Notification"(103 CREATE TABLE Notification ( 104 104 notification_id BIGSERIAL PRIMARY KEY, 105 105 user_id BIGINT NOT NULL, … … 115 115 116 116 117 CREATE TABLE "Review"(117 CREATE TABLE Review ( 118 118 review_id BIGSERIAL PRIMARY KEY, 119 119 reviewer_id BIGINT NOT NULL,
