Borad

Tables (5)

Authorities (AUTHORITIES)

  • id — nvarchar2(30) — NOT NULL
  • authority — nvarchar2(20) — NOT NULL

BoardTag (BOARDTAG)

  • bno — number — NOT NULL
  • tag — nvarchar2(50) — NOT NULL

Tag (TAG)

  • tag — nvarchar2(50) — NOT NULL
  • viewcnt — number — NOT NULL

User (USER)

  • id — nvarchar2(30) — Primary key — NOT NULL
  • pw — nvarchar2(50) — NOT NULL
  • name — nvarchar2(200) — NOT NULL

board (BOARD)

  • bno — number — Primary key — NOT NULL
  • title — nvarchar2(50) — NOT NULL
  • content — nvarchar2(2000) — NOT NULL
  • id — nvarchar2(30) — NOT NULL
  • regdate (rergdate) — date — NOT NULL
  • viewcnt — number — NOT NULL