지역주민 커뮤니티 활동 프로그램
테이블 (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