TeamProject
Tables (17)
Untitled (Toy_Auction_product)
- Key (Auction_P_no) — number — Primary key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (Auction_category_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_P_name) — varchar2(200) — NOT NULL
- Field (Auction_P_description) — varchar2(4000) — NOT NULL
- Field (Auction_P_permission) — varchar2(4) — NOT NULL
- Field (Auction_P_insertDate) — Date — NOT NULL
Untitled (Auction_chatJoinLog)
- Key (Auction_chatJoin_no) — number — Primary key — NOT NULL
- Key (Auction_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_chatJoin_date) — Date
Untitled (Auction_Message)
- Key (Auction_Message_no) — number — Primary key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_Sender) — varchar2(200) — NOT NULL
- Field (Auction_Content) — varchar2(4000) — NOT NULL
- Field (Auction_SendDate) — Date — NOT NULL
- Field (Auction_isChecked) — varchar2(4) — NOT NULL
Untitled (Auction_SuccessfulBider)
- Key (Auction_SB_no) — number — Primary key — NOT NULL
- Key (Auction_Bid_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_SuccessfulDate) — Date — NOT NULL
Untitled (Auction_category)
- Key (Auction_category_no) — number — Primary key — NOT NULL
- Field (Auction_grouping) — varchar2(200) — NOT NULL
Untitled (Toy_Auction_ Bid)
- Key (Auction_Bid_no) — number — Primary key — NOT NULL
- Key (Auction_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_Bid_price) — number — NOT NULL
- Field (Auction_Bid_Date) — Date — NOT NULL
Untitled (Auction_chat)
- Key (chat_no) — number — Primary key — NOT NULL
- Key (Auction_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (chat_content) — varchar2(2000) — NOT NULL
- Field (chat_writeDate) — Date — NOT NULL
Untitled (Toy_Auction)
- Key (Auction_no) — number — Primary key — NOT NULL
- Key (Auction_P_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Auction_startPrice) — number — NOT NULL
- Field (Auction_raisePrice) — number — NOT NULL
- Field (Auction_startDate) — Date — NOT NULL
- Field (Auction_endDate) — Date — NOT NULL
- Field (Auction_participants) — number — NOT NULL
Untitled (Auction_product_image)
- Key (AP_image_no) — number — Primary key — NOT NULL
- Key (Auction_P_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar2(4000) — NOT NULL
- Field (image_orl) — varchar2(4000) — NOT NULL
Untitled (DW_Member)
- Key (dw_member_no) — number — Primary key — NOT NULL
- Field (dw_member_id) — varChar2(30) — NOT NULL
- Field (dw_member_pw) — varChar2(100) — NOT NULL
- Field (dw_member_nick) — varChar2(10) — NOT NULL
- Field (dw_member_gender) — varChar2(4) — NOT NULL
- Field (dw_member_email) — varChar2(100) — NOT NULL
- Field (dw_member_phone) — varChar2(20)
- Field (dw_member_address) — varChar2(200) — NOT NULL
- Field (dw_member_joindate) — DATE — NOT NULL
- Field (dw_member_birth) — DATE — NOT NULL
- Field (dw_member_cash) — number — NOT NULL
Untitled (fs_comment_Empathize)
- Key (fs_comment_Empathize_no) — number — Primary key — NOT NULL
- Key (comment_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (dw_member_no) — number — NOT NULL
- Field (fs_comment_Empathize_check) — varchar2(4)
- Field (fs_comment_Empathize_date) — Date — NOT NULL
Untitled (fs_board_commentToComment)
- Key (fs_ToComment_no) — number — Primary key — NOT NULL
- Key (comment_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (fs_board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (Tocomment_content) — varchar2(1000) — NOT NULL
- Field (ToComment_writeDate) — Date — NOT NULL
Untitled (dw_member_visitDate)
- Key (dw_member_visitDate_no) — nember — Primary key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (dw_member_visitDate) — Date — NOT NULL
Untitled (fs_image_like)
- Key (fs_image_like_no) — number — Primary key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (fs_image_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (fs_image_like_date) — Date — NOT NULL
Untitled (fs_board_comment)
- Key (comment_no) — number — Primary key — NOT NULL
- Key (fs_board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (dw_member_no) — number — NOT NULL
- Field (comment_content) — varchar2(1500) — NOT NULL
- Field (comment_writedate) — date — NOT NULL
Untitled (fs_board_image)
- Key (fs_image_no) — number — Primary key — NOT NULL
- Key (fs_board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (image_uri) — varchar2(1000) — NOT NULL
- Field (image_ori) — varchar2(1000) — NOT NULL
Untitled (DW_Fashion_board)
- Key (fs_board_no) — number — Primary key — NOT NULL
- Key (dw_member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (fs_board_title) — varchar2(300) — NOT NULL
- Field (fs_board_content) — varchar2(4000) — NOT NULL
- Field (fs_board_readcount) — number — NOT NULL
- Field (fs_board_writedate) — date — NOT NULL
- Field (fs_board_category) — varchar2(100) — NOT NULL
- Field (fs_board_genderCategory) — varchar2(4) — NOT NULL