자신의 데이터베이스 요구명세서 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