123

Tables (5)

Board

  • bId — varchar — Primary key — NOT NULL
  • userId — varchar — Foreign key → Users.userId — NOT NULL
  • brp — varchar — Foreign key → Reply.brp — NOT NULL
  • fno — int — Foreign key → Files.fno — NOT NULL
  • title — varchar — NOT NULL
  • writer — varchar — NOT NULL
  • content — varchar — NOT NULL
  • reqDate — timestamp
  • ubo — timestamp
  • dbo — timestamp

Files

  • fno — int — Primary key — NOT NULL
  • bId — varchar
  • fnm — varchar
  • reqDate — timestamp

Members

  • userName (userId) — varchar — Primary key — NOT NULL
  • 기광우 (kkw180) — varchar
  • 정이산 (JIS108) — varchar
  • 홍길동 (HGD08) — varchar
  • 고길동 (GOG99) — varchar
  • 신창섭 (SHS13) — varchar
  • 강원기 (GWG) — varchar

Reply

  • brp — varchar — Primary key — NOT NULL
  • rId — varchar
  • writer — varchar
  • content — varchar
  • reqDate — timestamp
  • Field — VARCHAR(255)

Users

  • userId — varchar — Primary key — NOT NULL
  • userName — varchar — NOT NULL
  • pw — varchar — NOT NULL
  • tel — int — NOT NULL
  • gender — varchar — NOT NULL
  • reqDate — timestamp — NOT NULL