Kids Bank
Tables (7)
Board (board)
- 게시글ID (board_id) — Number — Primary key — NOT NULL — 기본키
- 자식ID (child_id) — Number — Foreign key → Child.자식ID — NOT NULL
- 제목 (title) — Varchar2(90) — NOT NULL
- 내용 (content) — Varchar2(4000) — NOT NULL
- 금액 (amount) — Number — NOT NULL
- 입금자 (sender) — Number
- 타입(입금, 소비) (type) — Char(1) — NOT NULL
- 카테고리(소비타입) (category) — Varchar2(30)
- 작성일 (created_at) — TimeStamp — NOT NULL
- 수정일 (updated_at) — TimeStamp — NOT NULL
- 공개여부 (is_hide) — Char(1) — NOT NULL
Child (child)
- 자식ID (child_id) — Number — Primary key — NOT NULL — 기본키
- 이름 (child_name) — Varchar2(50) — NOT NULL
- 이메일 (child_email) — Varchar2(50) — NOT NULL
- 생년월일 (child_birth) — Date — NOT NULL
- 닉네임 (child_nick) — Varchar2(50) — NOT NULL
- 비밀번호 (child_password) — Varchar2(50) — NOT NULL
- 전화번호 (child_phone) — Varchar2(13) — NOT NULL
- 잔액 (amount) — Number — NOT NULL
ChildLike (childlike)
- 자식좋아요ID (c_like_id) — Number — Primary key — NOT NULL — 기본키
- 게시글ID (board_id) — Number — Foreign key → Board.게시글ID — NOT NULL — 기본키
- 자식ID (child_id) — Number — Foreign key → Child.자식ID — NOT NULL — 기본키
- 좋아요여부 (is_liked) — Char(1) — NOT NULL
Comments (comments)
- 댓글ID (comment_id) — Number — Primary key — NOT NULL — 기본키
- 게시글ID (board_id) — Number — Foreign key → Board.게시글ID — NOT NULL
- 작성자 (commenter_id) — Number — NOT NULL
- 내용 (content) — Varchar2(4000) — NOT NULL
- 작성일 (created_at) — TimeStamp — NOT NULL
- 수정일 (updated_at) — TimeStamp — NOT NULL
ParentLike (parentlike)
- 부모좋아요ID (p_like_id) — Number — Primary key — NOT NULL — 기본키
- 게시글ID (board_id) — Number — Foreign key → Board.게시글ID — NOT NULL — 기본키
- 부모ID (parent_id) — Number — Foreign key → Parents.부모ID — NOT NULL — 기본키
- 좋아요여부 (is_liked) — Char(1) — NOT NULL
Parents (parents)
- 부모ID (parent_id) — Number — Primary key — NOT NULL — 기본키
- 이름 (user_name) — Varchar2(50) — NOT NULL
- 이메일 (parent_email) — Varchar2(50) — NOT NULL
- 닉네임 (parent_nick) — Varchar2(50) — NOT NULL
- 비밀번호 (parent_password) — Varchar2(50) — NOT NULL
- 전화번호 (parent_phone) — Varchar2(13) — NOT NULL
Relation (relation)
- 관계ID (relation_id) — Number — Primary key — NOT NULL — 기본키
- 부모ID (parent_id) — Number — Foreign key → Parents.부모ID — NOT NULL — 기본키
- 자식ID (child_id) — Number — Foreign key → Child.자식ID — NOT NULL — 기본키
- 관계 (relation) — Varchar2(9) — NOT NULL