ERD_Example_11_21

Tables (5)

BOARD (게시글)

  • BNO (글번호) — NUMBER(5) — Primary key — NOT NULL
  • TITLE (게시글이름) — VARCHAR2(50)
  • REGDATE (게시글등록일) — DATE
  • ID (ID2) — VARCHAR2(10) — Foreign key → ID.ID — NOT NULL

FRIEND_LIST (친구목록)

  • FRIEND (친구) — VARCHAR2(10) — Primary key — NOT NULL
  • ID — VARCHAR2(10) — Foreign key → ID.ID — NOT NULL

ID

  • ID — VARCHAR2(10) — Primary key — NOT NULL
  • NAME (회원이름) — VARCHAR2(5)
  • ADRESS (회원주소) — VARCHAR2(4)
  • PHONE (회원연락처) — VARCHAR2(13)

LIKE (좋아요)

  • LIKE (좋아요) — NUMBER(5) — Primary key — NOT NULL
  • ID (ID2) — VARCHAR2(10) — Foreign key → ID.ID — NOT NULL
  • BNO (글번호) — NUMBER(5) — Foreign key → BOARD.BNO — NOT NULL

RE (댓글)

  • RNO (댓글번호) — NUMBER(5) — Primary key — NOT NULL
  • R_TITLE (댓글제목) — VARCHAR2(20)
  • R_CONTENT (댓글내용) — VARCHAR2(50)
  • R_REGDATE (댓글등록일) — DATE
  • ID (댓글쓴이) — VARCHAR2(10) — Foreign key → ID.ID — NOT NULL
  • BNO (글번호2) — NUMBER(5) — Foreign key → BOARD.BNO — NOT NULL