shopping mall
Tables (4)
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_Goods)
- Key (gd_no) — NUMBER — Primary key — NOT NULL
- sh_no — NUMBER — Foreign key → dw_ shop.sh_no — NOT NULL
- Field (gd_name) — varChar2(100) — NOT NULL
- Field (gd_Price) — number — NOT NULL
- Field (gd_img) — varChar2(400) — NOT NULL
- Field (gd_Quantity) — number — NOT NULL
- Field (gd_date) — DATE — NOT NULL
Untitled (dw_Order)
- Key (od_no) — number — Primary key — NOT NULL
- dw_member_no — number — Foreign key → DW_Member.dw_member_no — NOT NULL
- Key (gd_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (od_Quantity) — number — NOT NULL
- Field (od_date) — DATE — NOT NULL
dw_ shop (dw_shop)
- 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) — NOT NULL
- Field (sh_content) — varChar2(5000) — NOT NULL
- Field (sh_img) — varChar2(400) — NOT NULL
- Field (sh_date) — DATE — NOT NULL