musthave

Tables (4)

MVCBoard

  • idx — number — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • postdate — date — NOT NULL
  • ofile — varchar2(200)
  • sfile — varchar2(30)
  • downcount — number — NOT NULL
  • pass — varchar2(50) — NOT NULL
  • visitcount — number — NOT NULL

board

  • num — number — Primary key — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • id — varchar2(10) — Foreign key → member.id — NOT NULL
  • postdate — date — NOT NULL
  • visitcount — number(6)

member

  • id — varchar2(10) — Primary key — NOT NULL
  • pass — varchar2(10) — NOT NULL
  • name — varchar2(30) — NOT NULL
  • regidate — date — NOT NULL

myfile

  • idx — number — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • cate — varchar2(30)
  • ofile — varchar2(100) — NOT NULL
  • sfile — varchar2(30) — NOT NULL
  • postdate — date — NOT NULL