test

Tables (8)

DW_Fashion_board

  • fs_board_no — number — Primary key — NOT NULL
  • dw_member_no — number — Foreign key → 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

DW_Member

  • dw_member_no — number — Primary key — 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 — DATE — NOT NULL
  • dw_member_cash — number — NOT NULL

fs_GenderCategory (Untitled2)

    fs_board_Like

    • like_no — number — Primary key — NOT NULL
    • fs_board_no — number — Foreign key → DW_Fashion_board.fs_board_no — NOT NULL
    • dw_member_no — number — Foreign key → DW_Fashion_board.dw_member_no — NOT NULL
    • like_date — date — NOT NULL

    fs_board_comment

    • comment_no — number — Primary key — NOT NULL
    • fs_board_no — number — Foreign key → DW_Fashion_board.fs_board_no — NOT NULL
    • dw_member_no — number — Foreign key → DW_Fashion_board.dw_member_no — NOT NULL
    • comment_content — varchar2(1500) — NOT NULL
    • comment_writedate — date — NOT NULL

    fs_board_image

    • fs_image_no — number — Primary key — NOT NULL
    • fs_board_no — number — Foreign key → DW_Fashion_board.fs_board_no — NOT NULL
    • image_uri — varchar2(1000) — NOT NULL
    • image_ori — varchar2(1000) — NOT NULL

    fs_category (Untitled)

    • Key — Primary key — NOT NULL

    fs_image_like

    • fs_image_like_no — number — Primary key — NOT NULL
    • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
    • fs_image_no — number — Foreign key → fs_board_image.fs_image_no — NOT NULL
    • fs_board_no — number — Foreign key → fs_board_image.fs_board_no — NOT NULL
    • fs_image_like_date — Date — NOT NULL