Druwa

Tables (22)

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 — varChar2(20) — NOT NULL
  • dw_member_cash — number — NOT NULL

Untitled (DW_Order)

  • Key (od_no) — NUMBER — Primary key — NOT NULL
  • Key (gd_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (od_quantity) — NUMBER
  • Field (od_date) — DATE

Untitled (Jackpot)

  • Key (dw_jackpot_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (dw_jackpot_funds) — NUMBER
  • Field (dw_jackpot_get) — NUMBER
  • Field (dw_jackpot_date) — DATE

Untitled (DW_Slot_log)

  • Key (dw_slot_log_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (dw_slot_log_bettingCoin) — NUMBER
  • Field (dw_slot_log_one) — NUMBER
  • Field (dw_slot_log_twon) — NUMBER
  • Field (dw_slot_log_three) — NUMBER
  • Field (dw_slot_log_dividend) — NUMBER
  • Field (dw_slot_log_date) — DATE

Untitled (DW_Toy_SysMessage)

  • Key (toy_Sm_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (toy_sM_title) — VARCHAR2(80) — NOT NULL
  • Field (toy_sM_content) — VARCHAR2(4000) — NOT NULL
  • Field (toy_sM_sendDate) — DATE — 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

Untitled (Toy_Auction_Bid)

  • Key (Auction_Bid_no) — NUMBER — Primary key — NOT NULL
  • Key (Auction_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (Auction_Bid_price) — NUMBER
  • Field (Auction_Bid_Date) — DATE

Untitled (Auction_ChatJoinLog)

  • Key (Auction_chatJoin_no) — NUMBER — Primary key — NOT NULL
  • Key (Auction_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (Auction_chatJoin_date) — DATE

Untitled (Auction_Chat)

  • Key (chat_no) — NUMBER — Primary key — NOT NULL
  • Key (Auction_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (chat_content) — VARCHAR2(2000)
  • Field (chat_writeDate) — DATE

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
  • Field (Auction_raisePrice) — NUMBER
  • Field (Auction_startDate) — DATE
  • Field (Auction_endDate) — DATE
  • Field (Auction_participants) — NUMBER

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)
  • Field (image_orl) — VARCHAR2(4000)

Untitled (Auction_category)

  • Key (Auction_category_no) — NUMBER — Primary key — NOT NULL
  • Field (Auction_grouping) — VARCHAR2(200)

Untitled (DW_Toy_Product)

  • Key (toy_pd_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Key (toy_pC_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (toy_pd_name) — VARCHAR2(40) — NOT NULL
  • Field (toy_pd_price) — NUMBER — NOT NULL
  • Field (toy_pd_explanation) — VARCHAR2(500)
  • Field (toy_pd_stock) — NUMBER — NOT NULL
  • Field (toy_pd_place) — VARCHAR2(100) — NOT NULL
  • Field (toy_pd_registrationdate) — DATE — NOT NULL
  • Field (toy_pd_readCount) — NUMBER

Untitled (DW_Goods)

  • Key (gd_no) — NUMBER — Primary key — NOT NULL
  • Key (sh_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (gd_name) — VARCHAR2(100)
  • Field (gd_price) — NUMBER
  • Field (gd_quantity) — NUMBER
  • Field (gd_img) — VARCHAR2(400)
  • Field (gd_date) — DATE

Untitled (DW_Shop)

  • Key (sh_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (sh_name) — VARCHAR2(400)
  • Field (sh_content) — VARCHAR2(5000)
  • Field (sh_img) — VARCHAR2(400)
  • Field (sh_date) — DATE

Untitled (DW_Toy_ProductPurchaseReview)

  • Key (toy_ppR_no) — NUMBER — Primary key — NOT NULL
  • Key (toy_aO_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (toy_ppR_reviewScore) — NUMBER — NOT NULL
  • Field (toy_ppR_reviewContent) — VARCHAR2(500) — NOT NULL
  • Field (toy_ppR_reviewdate) — DATE — NOT NULL

Untitled (Toy_Auction_Product)

  • Key (Auction_P_no) — NUMBER — Primary key — NOT NULL
  • dw_member_no — NUMBER — Foreign key → DW_Member.dw_member_no — 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)
  • Field (Auction_P_insertDate) — DATE — NOT NULL

Untitled (DW_Toy_ProductCategory)

  • Key (toy_pC_no) — NUMBER — Primary key — NOT NULL
  • Field (toy_pC_grouping) — VARCHAR2(20) — NOT NULL

Untitled (DW_Toy_ProductImageFile)

  • Key (toy_pdiF_no) — NUMBER — Primary key — NOT NULL
  • Key (toy_pd_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (toy_pdiF_url) — VARCHAR2(400) — NOT NULL

Untitled (DW_Toy_ProductSaleReview)

  • Key (toy_psR_no) — NUMBER — Primary key — NOT NULL
  • Key (toy_aO_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (toy_psR_reviewScore) — NUMBER — NOT NULL
  • Field (toy_psR_reviewContent) — VARCHAR2(500) — NOT NULL
  • Field (toy_psR_reviewdate) — DATE — NOT NULL

Untitled (DW_Toy_ApplyOrder)

  • Key (toy_aO_no) — NUMBER — Primary key — NOT NULL
  • Key (toy_pd_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
  • Field (toy_aO_purquentity) — NUMBER — NOT NULL
  • Field (toy_aO_clearingPrice) — NUMBER — NOT NULL
  • Field (toy_aO_orderstate) — VARCHAR2(20) — NOT NULL
  • Field (toy_aO_applyOrderDate) — DATE — NOT NULL

Untitled2 (DW_Admin_Member)

  • Key (ad_member_no) — NUMBER — Primary key — NOT NULL
  • Field (ad_member_id) — VARCHAR2(30) — NOT NULL
  • Field (ad_member_pw) — VARCHAR2(300) — NOT NULL
  • Field (ad_member_name) — VARCHAR2(10) — NOT NULL
  • Field (ad_member_createdate) — DATE — NOT NULL