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