프로젝트 DW

테이블 (5)

DW_Fashion_board

  • fs_board_no — number — 기본 키 — NOT NULL
  • dw_member_no — number — 외래 키 → DW_Member.dw_member_no — NOT NULL
  • fs_board_title — varchar2(300) — NOT NULL
  • fs_board_content — varchar2(4000) — NOT NULL
  • fs_board_readcount — number — NOT NULL
  • fs_board_writedate — date — NOT NULL
  • fs_board_category — varchar2(100) — NOT NULL

DW_Member

  • dw_member_no — number — 기본 키 — NOT NULL
  • dw_member_id — varChar2(30) — NOT NULL
  • dw_member_pw — varChar2(100) — NOT NULL
  • dw_member_nick — varChar2(10) — NOT NULL
  • dw_member_gender — varChar2(4) — NOT NULL
  • dw_member_email — varChar2(100) — NOT NULL
  • dw_member_phone — varChar2(20)
  • dw_member_address — varChar2(200) — NOT NULL
  • dw_member_joindate — DATE — NOT NULL
  • dw_member_birth — varChar2(20) — NOT NULL
  • dw_member_cash — number — NOT NULL

fs_board_Like

  • like_no — number — 기본 키 — NOT NULL
  • dw_member_no — number — 기본 키 — NOT NULL
  • fs_board_no — number — 외래 키 → DW_Fashion_board.fs_board_no — NOT NULL
  • like_date — date — NOT NULL

fs_board_comment

  • comment_no — number — 기본 키 — NOT NULL
  • fs_board_no — number — 기본 키 — NOT NULL
  • dw_member_no — number — 기본 키 — NOT NULL
  • comment_content — varchar2(1500) — NOT NULL
  • comment_writedate — date — NOT NULL

fs_board_image

  • fs_image_no — number — 기본 키 — NOT NULL
  • fs_board_no — number — 외래 키 → DW_Fashion_board.fs_board_no — NOT NULL
  • image_uri — varchar2(1000) — NOT NULL
  • image_ori — varchar2(1000) — NOT NULL