practice

Tables (3)

Board (Untitled2)

  • bno (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → User.ID — NOT NULL — 아이디
  • writer (Field) — NOT NULL — 아이디
  • title (Field2) — NOT NULL
  • coment (Field3)

Reply (Untitled3)

  • rno (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → User.ID — NOT NULL — 아이디
  • bno (Key3) — Foreign key → Board.bno — NOT NULL
  • ID (Key22) — Foreign key → Board.ID — NOT NULL — 아이디
  • bno (Field) — NUMBER(10) — NOT NULL
  • writer (Field2) — VARCHAR2(30 — NOT NULL — 아이디
  • Field3 — VARCHAR2(500) — NOT NULL

User (Untitled)

  • ID (Key) — Primary key — NOT NULL — 아이디
  • name (Field) — NOT NULL — 이름
  • pw (Field2) — NOT NULL — 비밀번호
  • address (Field3) — NOT NULL — 주소
  • reg_date (Field4) — 주소