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