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