2nd
Tables (10)
Untitled (PEOPLE)
- Key (peopleId) — serial — Primary key — NOT NULL
- Field (name) — varchar(10)
- Field (address) — varchar(70)
- Field (phone) — varchar(20)
- Field (joinYear) — integer
Untitled (ACTIVITY_APPLICATION)
- Key (activityId) — serial — Foreign key → Untitled5.Key — NOT NULL
- Key (peopleId) — serial — Foreign key → Untitled.Key — NOT NULL
- Field (applicationDate) — date
Untitled2 (POST)
- Key (postId) — serial — Primary key — NOT NULL
- Field (title) — varchar(30)
- Field (content) — text
- Field (createDate) — date
- Key (peopleId) — serial — Foreign key → Untitled.Key — NOT NULL
- Key (communityId) — serial — Foreign key → Untitled4.Key — NOT NULL
- Key (instructorId) — serial — Foreign key → Untitled4.Key — NOT NULL
Untitled3 (PEOPLE_COMMUNITY)
- Key (peopleId) — serial — Foreign key → Untitled.Key — NOT NULL
- Key (communityId) — serial — Foreign key → Untitled4.Key — NOT NULL
- Key (instructorId) — serial — Foreign key → Untitled4.Key — NOT NULL
- Field (joinDate) — date
- Field (price) — integer
Untitled4 (COMMUNITY)
- Key (communityId) — serial — Primary key — NOT NULL
- Key (instructorId) — serial — Foreign key → Untitled9.Key — NOT NULL
- Field (title) — varchar(50)
- Field (description) — text
- Field (createYear) — integer
Untitled5 (ACTIVITY)
- Key (activityId) — serial — Primary key — NOT NULL
- Field (title) — varchar(50)
- Field (description) — text
- Field (startDate) — date
- Field (maxCapacity) — integer
- Field (durationMin) — integer
Untitled6 (COMMUNITY_ACTIVITY)
- Key (communityId) — serial — Foreign key → Untitled4.Key — NOT NULL
- Key (instructorId) — serial — Foreign key → Untitled4.Key — NOT NULL
- Key (activityId) — serial — Foreign key → Untitled5.Key — NOT NULL
- Field (relationType)
Untitled7 (SPACE_ALLOCATION)
- Key (activityId) — serial — Foreign key → Untitled5.Key — NOT NULL
- Key (spaceId) — serial — Foreign key → Untitled8.Key — NOT NULL
- Field (allocDate) — date
- Field (startTime) — integer
- Field (endTime) — integer
Untitled8 (SPACE)
- Key (spaceId) — serial — Primary key — NOT NULL
- Field (spaceName) — varchar(50)
- Field (location) — text
- Field (capacity) — integer
- Field (available) — Y/N
Untitled9 (INSTRUCTOR)
- Key (instructorId) — serial — Foreign key → Untitled.Key — NOT NULL
- Field (majorField) — varchar(50)
- Field2 (biography) — text
- Field2 (cerification) — varchar(10)