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