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