WFF

Tables (9)

FAQ

  • bno — number(10,0) — Primary key — NOT NULL
  • category — varchar2(50) — NOT NULL
  • writer — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • regdate — date

Faq_Category

  • category — varchar2(50) — Primary key — NOT NULL
  • categoryname — varchar2(200) — NOT NULL

Inquiry

  • inquirybno — number(10,0)
  • id — varchar2(20) — Foreign key → Member.id — NOT NULL
  • incategory — varchar2(50) — Foreign key → inquiry_Category.incategory — NOT NULL
  • writer — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • replyDate — date
  • updateDate — date

Inquiry_reply

  • rno — number(10,0)
  • inquirybno — number(10,0)
  • reply — varchar2(1000) — NOT NULL
  • replyer — varchar2(50) — NOT NULL
  • replyDate — date
  • updateDate — date

Member

  • id — varchar2(20) — Primary key — NOT NULL
  • password — varchar2(40) — NOT NULL
  • email — varchar2(80) — NOT NULL
  • name — varchar2(20) — NOT NULL
  • address1 — varchar2(100) — NOT NULL
  • address2 — varchar2(100) — NOT NULL
  • address3 — varchar2(100) — NOT NULL

Notice

  • noticebno — number(10, 0)
  • admin — varchar2(50) — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • regdate — date

WFFLAB_board

  • bno — number(10, 0) — Primary key — NOT NULL
  • id — varchar2(20) — Foreign key → Member.id — NOT NULL
  • title — varchar2(200) — NOT NULL
  • content — varchar2(2000) — NOT NULL
  • writer — varchar2(50) — NOT NULL
  • replycnt — number(10)
  • regdate — date
  • updatedate — date

WFFLAB_reply

  • rno — number(10,0)
  • bno — number(10, 0) — NOT NULL
  • reply — varchar2(1000) — NOT NULL
  • replyer — varchar2(50) — NOT NULL
  • replyDate — date
  • updateDate — date

inquiry_Category

  • incategory — varchar2(50) — NOT NULL
  • categoryname — varchar2(200) — NOT NULL