ShinNanDa
Tables (12)
Untitled (SN_Member)
- Key (member_no) — NUMBER — Primary key — NOT NULL
- Field (member_name) — VARCHAR2(20)
- Field (member_id) — VARCHAR2(20)
- Field (member_pw) — VARCHAR2(400)
- Field (member_nick) — VARCHAR2(20)
- Field (member_gender) — VARCHAR2(1)
- Field (member_birth) — DATE
- Field (member_phone) — VARCHAR2(20)
- Field (member_address) — VARCHAR2(1000)
- Field (member_email) — VARCHAR2(100)
- Field2 (member_joindate) — DATE
- Field (member_admin) — VARCHAR2(1)
Untitled (SN_Product_Detail)
- Key (product_detail_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (product_detail_option) — VARCHAR2(1000)
- Field2 (product_detail_stock) — NUMBER
Untitled (SN_Product)
- Key (product_no) — NUMBER — Primary key — NOT NULL
- Key (product_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (brand_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (product_title) — VARCHAR2(50)
- Field (product_model) — VARCHAR2(50)
- Field (product_price) — NUMBER(15)
- Field (product_image) — VARCHAR2(500)
- Field (product_date) — DATE
- Field (product_content) — VARCHAR2(1000)
Untitled (SN_type_catecory)
- Key (product_category_no) — NUMBER — Primary key — NOT NULL
- Field (product_category_name) — VARCHAR2(45)
Untitled (SN_Orders)
- Key (orders_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (orders_state) — VARCHAR2(45)
- Field (orders_date) — DATE
- Field (orders_name) — VARCHAR2(20)
- Field2 (orders_phone) — VARCHAR2(30)
- Field (orders_address) — VARCHAR2(1000)
Untitled (SN_Orders_Detail)
- Key (orders__detail_no) — NUMBER — Primary key — NOT NULL
- Key (orders_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (product_detail_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (orders_detail_count) — NUMBER
Untitled (SN_Cart)
- Key (cart_no) — NUMBER — Primary key — NOT NULL
- Key (product_detail_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (cart_count) — NUMBER
Untitled (SN_Image)
- Key (image_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR2(4000)
Untitled (SN_brand_category)
- Key (brand_no) — NUMBER — Primary key — NOT NULL
- Field (brand_name) — VARCHAR2(100)
Untitled (SN_Payment)
- Key (payment_no) — NUMBER — Primary key — NOT NULL
- Key (orders_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (payment_method) — VARCHAR2(45)
- Field (payment_date) — DATE
Untitled (SN_MemberHobby)
- Key (memberhobby_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (hobby_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (SN_Hobby_Category)
- Key (hobby_category_no) — NUMBER — Primary key — NOT NULL
- Field (hobby_category_name) — VARCHAR2(100)