내가 해본거

테이블 (4)

comments

  • no — NUMBER — 기본 키 — NOT NULL
  • board_no — NUMBER — 외래 키 → posts.no — NOT NULL
  • user_no — NUMBER — 외래 키 → users.no — NOT NULL
  • content — CLOB
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

files

  • no — NUMBER — 기본 키 — NOT NULL
  • board_no — NUMBER — 외래 키 → posts.no — NOT NULL
  • file_name — VARCHAR2(100) — NOT NULL
  • file_path — VARCHAR2(2000) — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

posts

  • no — NUMBER — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → users.no — NOT NULL
  • username — VARCHAR2(100) — NOT NULL
  • content — CLOB
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

users

  • no — NUMBER — 기본 키 — NOT NULL
  • username — VARCHAR2(100)
  • password — VARCHAR2(100) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • email — VARCHAR2(200) — NOT NULL