지역주민 커뮤니티 활동 프로그램

테이블 (8)

Untitled (PEOPLE)

  • Key (peopleId) — serial — 기본 키 — NOT NULL
  • Field (name) — varchar(10)
  • Field (address) — varchar(70)
  • Field (phone) — varchar(20)
  • Field (joinYear) — integer

Untitled (INSTRUCTOR)

  • Key (instructorId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Field (majorField) — varchar(50)
  • Field2 (biogaphy) — text
  • Field2 (certification) — varchar(10)

Untitled (COMMUNITY)

  • Key (communityId) — serial — 기본 키 — NOT NULL
  • Key (instructorId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — varchar(50)
  • Field (description) — text
  • Field (createYear) — integer
  • Field (maxCapacity) — integer
  • Field (durationMin) — integer
  • Key (activityId) — serial — 외래 키 → Untitled.Key — NOT NULL

Untitled (ACTIVITY)

  • Key (activityId) — serial — 기본 키 — NOT NULL
  • Field (title) — varchar(50)
  • Field (description) — text

Untitled (POST)

  • Key (postId) — serial — 기본 키 — NOT NULL
  • Field (title) — varchar(30)
  • Field (content) — text
  • Field (createDate) — date
  • Key (peopleId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (communityId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (instructorId) — serial — 외래 키 → Untitled.Key — NOT NULL

Untitled (SPACE)

  • Key (spaceId) — serial — 기본 키 — NOT NULL
  • Field (spaceName) — varchar(50)
  • Field (location) — text
  • Field (capacity) — integer
  • Field (available) — Y/N

Untitled (PEOPLE_COMMUNITY)

  • Key (peopleId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (communityId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (instructorId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Field (applicationDate) — date

Untitled (SPACE_COMMUNITY)

  • Key (spaceId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (communityId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Key (instructorId) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Field (allocDate) — date
  • Field (startTime) — integer
  • Field (endTime) — integer