20221121EX

테이블 (5)

BOARD (글)

  • BNO — NUMBER(10) — 기본 키 — NOT NULL
  • Key (ID) — VARCHAR2(3) — 외래 키 → Untitled.Key — NOT NULL
  • Field (BOARDNAME) — VARCHAR2(30)
  • Field (BOARDDATE) — DATE

Untitled (회원)

  • Key (ID) — VARCHAR2(3) — 기본 키 — NOT NULL
  • Field (NAME) — VARCHAR2(30)
  • Field (ADDRESS) — VARCHAR2(30)
  • Field (PHONENUM) — NUMBER(10)

Untitled (회원친구)

  • Key (ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Key (FID) — VARCHAR2(30) — 외래 키 → Untitled.Key — NOT NULL

댓글 (RE)

  • Key (RNO) — NUMBER(10) — 기본 키 — NOT NULL
  • BNO — NUMBER(10) — 외래 키 → BOARD.BNO — NOT NULL
  • Field (RENAME) — VARCHAR2(30)
  • Field (REIN) — VARCHAR2(30)
  • Field (REDATE) — DATE
  • Key (ID) — VARCHAR2(3) — 외래 키 → Untitled.Key — NOT NULL

좋아요 (LIKE)

  • BNO — NUMBER(10) — 외래 키 → BOARD.BNO — NOT NULL
  • Key (ID) — VARCHAR2(3) — 외래 키 → Untitled.Key — NOT NULL
  • Field (좋아요수) — NUMBER(10)