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