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