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