BR
Tables (11)
Copy Of Untitled (BR_Catelevel2)
- Key (catelevel2_no) — NUMBER — Primary key — NOT NULL
- Key (catelevel1_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (catelevel2_name) — VARCHAR2(30)
Untitled (BR_Admin)
- Key (admin_no) — NUMBER — Primary key — NOT NULL
- Field (admin_id) — VARCHAR2(20)
- Field (admin_pw) — VARCHAR2(30)
- Field (admin_phone) — VARCHAR2(20)
- Field (admin_email) — VARCHAR2(50)
- Field (admin_joindate) — DATE
Untitled (BR_Product)
- Key (prod_no) — NUMBER — Primary key — NOT NULL
- Key (admin_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (catelevel2_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (prod_code) — VARCHAR2(20)
- Field (prod_name) — VARCHAR2(50)
- Field (prod_desc) — VARCHAR2(30)
- Field (prod_stock_status) — VARCHAR(1)
- Field (prod_date) — DATE
Untitled (BR_ProdImage)
- Key (img_no) — NUMBER — Primary key — NOT NULL
- Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (img_url) — VARCHAR2(300)
- Field (img_origin_filename) — VARCHAR2(400)
Untitled (BR_Catelevel1)
- Key (catelevel1_no) — NUMBER — Primary key — NOT NULL
- Field (catelevel1_name) — VARCHAR2(30)
Untitled (BR_ThumbImage)
- Key (nail_no) — NUMBER — Primary key — NOT NULL
- Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (nail_url) — VARCHAR2(300)
- Field (nail_origin_filename) — VARCHAR2(400)
Untitled (BR_User)
- Key (user_no) — NUMBER — Primary key — NOT NULL
- Field (user_id) — VARCHAR2(50)
- Field (user_pw) — VARCHAR2(50)
- Field (user_name) — VARCHAR2(50)
- Field (user_phone) — VARCHAR2(20)
- Field (user_email) — VARCHAR2(50)
- Field (user_addr) — VARCHAE2(100)
- Field (user_joindate) — DATE
Untitled (buy_option1)
- Key (op1_no) — NUMBER — Primary key — NOT NULL
- Field (name) — VARCHAR2(10)
Untitled (buy_option2)
- Key (op2_no) — NUMBER — Primary key — NOT NULL
- Key (op1_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR2(10)
- Field (price) — NUMBER
Untitled (BR_Cart)
- Key (cart_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (op2_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (count) — NUMBER
Untitled (BR_Order)
- Key (order_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (prod_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (op2_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (count) — NUMBER
- Field (order_date) — DATE