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)