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