MWC
테이블 (6)
board(게시판) (Untitled4)
- num (Key) — number — 기본 키 — NOT NULL
- writer (Field) — varchar
- subject (Field2) — varchar
- passwd (Field3) — varchar
- reg_date (Field4) — date
- ref (Field5) — number
- re_step (Field6) — number
- re_level (Field7) — number
- content (Field8) — varchar
- ip (Field9) — varchar
- filename (Field10) — varchar
- filesize (Field11) — number
- down (Field12) — number
board_comment (게시판댓글) (Untitled5)
- comment_num (댓글번호) — number — 기본 키 — NOT NULL
- num (Key) — number — 외래 키 → board(게시판).num — NOT NULL
- board_num (Foreign key) — number
- writer (Field2) — varchar
- content (Field3) — clob
- reg_date (Field4) — date
guestbook(방명록) (Untitled)
- idx (Key) — num — 기본 키 — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- passwd (Field3) — varchar
- content (Field4) — varchar
- post_date (Field5) — date
member(회원) (Untitled6)
- userid (회원아이디) — varchar — 기본 키 — NOT NULL
- passwd (Field) — varchar
- name (Field2) — varchar
- email (Field3) — varchar
- hp (Field4) — varchar
- zipcode (Field5) — varchar
- address1 (Field6) — varchar
- address2 (Field7) — varchar
- join_date (Field8) — date
survey(설문조사) (Untitled2)
- survey_idx (Key) — number — 기본 키 — NOT NULL
- question (Field) — varchar
- ans1 (Field2) — varchar
- ans2 (Field3) — varchar
- ans3 (Field4) — varchar
- ans4 (Field5) — varchar
- status (Field6) — char
- Field7
survey_result(설문조사결과) (Untitled3)
- answer_idx (Key) — number — 기본 키 — NOT NULL
- survey_idx (Key2) — number — 외래 키 → survey(설문조사).survey_idx — NOT NULL
- survey_idx (foreign key) — number
- num (Field2) — number