자신의 데이터베이스 요구명세서 ERD
테이블 (8)
Untitled (PRIME_OF_LIFE_GROUP)
- Key (manaCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (baptism) — char(1)
- Field (guider) — char(20)
- Field (birthDate) — date
- Field (gender) — char(2)
- Key (evanCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (miniCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (YOUTH_GROUP)
- Key (manaCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (baptism) — char(1)
- Field (guider) — char(20)
- Field (birthDate) — date
- Field (gender) — char(2)
- Key (evanCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (miniCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MIDDLE_HIGH_GROUP)
- Key (manaCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (baptism) — char(1)
- Field (guider) — char(20)
- Field (birthDate) — date
- Field (gender) — char(2)
- Key (evanCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (miniCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MINISTER)
- Key (miniCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (birthDate) — date
- Field (seminaryOrigin) — char(20)
- Field (gender) — char(2)
Untitled (EVANGEFESTIVAL)
- Key (evanCode) — char(10) — 기본 키 — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (festivalDate) — date
- Field (location) — char(30)
- Field (participant) — char(3)
Untitled (FESTIVAL_AWARD)
- Key (awardCode) — char(10) — 기본 키 — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(20)
Untitled (FESTIVALWORK)
- Key (workCode) — char(10) — 기본 키 — NOT NULL
- Field (workName) — char(20)
Untitled2 (NURSERY_JUNIOR_GROUP)
- Key (manaCode) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (baptism) — char(1)
- Field (guider) — char(20)
- Field (birthDate) — date
- Field (gender) — char(2)
- Key (evanCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (workCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (miniCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL