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