Christmas

Tables (8)

CHILD (보육원생)

  • Key (id) — UUID — Primary key — NOT NULL
  • 보육원ID (orphanage_id) — UUID — Foreign key → ORPHANAGE.Key — NOT NULL
  • 아이디 (loginId) — VARCHAR
  • 비밀번호 (password) — VARCHAR

GIFT (기부품목)

  • Key (id) — UUID — Primary key — NOT NULL
  • 유저ID (user_id) — UUID — Foreign key → USER.Key — NOT NULL
  • 보육원ID (orphanage_id) — UUID — Foreign key → ORPHANAGE.Key — NOT NULL
  • 상품명 (name) — VARCHAR
  • 제품상태 (status) — VARCHAR
  • 기부자연락처 (donatorPhoneNumber) — VARCHAR
  • 기부자주소 (donatorAddress) — VARCHAR

LETTER (편지)

  • Key (id) — UUID — Primary key — NOT NULL
  • 유저ID (user_id) — UUID — Foreign key → USER.Key — NOT NULL
  • 트리ID (tree_id) — UUID — Foreign key → TREE.Key — NOT NULL
  • 내용 (content) — VARCHAR
  • 아이콘 (icon) — VARCHAR

LETTER_REPLY (편지답장)

  • Key (id) — UUID — Primary key — NOT NULL
  • 편지ID (letter_id) — UUID — Foreign key → LETTER.Key — NOT NULL
  • 보육원생ID (child_id) — UUID — Foreign key → CHILD.Key — NOT NULL

ORPHANAGE (보육원)

  • Key (id) — UUID — Primary key — NOT NULL
  • 아이디 (loginId) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 보육원 이름 (name) — VARCHAR
  • 주소(시/도) (si) — VARCHAR
  • 주소(구/군) (gu) — VARCHAR
  • 주소(동/읍/면) (dong) — VARCHAR
  • 보육원코드 (code) — VARCHAR
  • 필요트리개수 (requiredTreeQuantity) — INTEGER
  • 보육원설명 (description) — VARCHAR
  • 연락처 (phoneNumber) — VARCHAR

ORPHANAGE_PHOTO (보육원사진)

  • Key (id) — UUID — Primary key — NOT NULL
  • 보육원ID (ophanage_id) — UUID — Foreign key → ORPHANAGE.Key — NOT NULL
  • 이미지URL (imageUrl) — VARCHAR

TREE (트리)

  • Key (id) — UUID — Primary key — NOT NULL
  • 보육원ID (orphanage_id) — UUID — Foreign key → ORPHANAGE.Key — NOT NULL

USER (일반회원)

  • Key (id) — UUID — Primary key — NOT NULL
  • 닉네임 (nickname) — VARCHAR
  • 아이디 (loginId) — VARCHAR
  • 비밀번호 (password) — VARCHAR