shopping
Tables (9)
Untitled (shopping_member_address)
- Key (m_id) — Foreign key → shopping _member.Key — NOT NULL
- Field (m_address-name)
- Field2 (m_address_phone) — null
- Field (m_address) — null
Untitled (shoppintg_product_review)
- member_id (Key) — Primary key — NOT NULL
- product_no (varchar2(30)) — Primary key
- Field2 (char(8))
- product_review_content (varchar2(1500))
- Field4 (number(1))
- Field (product_review_date) — null
Untitled (coupon)
- c_no (varchar2(30)) — Primary key — NOT NULL
- seller_id (varchar2()30)) — Foreign key → shopping_seller.seller_id — NOT NULL
- c_effective_date (date)
- c_price (number)
Untitled (shopping_order)
- order_no (char(8)) — not null — Primary key — NOT NULL
- Key (m_id) — Foreign key → shopping _member.Key — NOT NULL
- Key (m_grade_no) — not null — Foreign key → shopping _member.Key — NOT NULL
- order_date (date)
- order_adress (varchar2(100)) — null
- order_address_name (varchar2(50)) — null
- order_address_tel (char(11)) — null
- order_ea (number)
- order_credit_money (order_pay)
- order_credit_kind (number(1))
shopping _member (shopping_member)
- Key (m_id) — Primary key — NOT NULL
- Key (m_grade_no) — not null — Foreign key → shopping_member_grade.Key — NOT NULL
- Field (m_passwd)
- Field2 (m_name)
- Field3 (m_phone)
- Field4 (m_email)
- Field5 (m_point)
- Field (m_birth)
- Field2 (m_grade)
shopping_member_grade
- Key (m_grade_no) — not null — Primary key — NOT NULL
- Field (m_grade_name) — null
shopping_parcel (Untitled)
- parcel_no (char(4)) — not null — Primary key — NOT NULL
- member_id (Key) — Foreign key → Untitled.member_id — NOT NULL
- product_no (varchar2(30)) — Foreign key → Untitled.product_no
- parcel_name (varchar2(50))
- parcel_tel_no (char(11))
- parcel_price (number)
shopping_product (product)
- Key (product_no) — not null — Primary key — NOT NULL
- Key (seller_id) — not null — Foreign key → shopping_seller.seller_id — NOT NULL
- Field (product_name) — null
- Field2 (product_origin) — null
- Field3 (product_ea) — null
- Field4 (product_price) — null
- Field (product_kc_no) — null
- Field3 (product_main_img)
- Field (product_sumbnail_img)
shopping_seller
- seller_id (varchar2()30)) — Primary key — NOT NULL
- seller_passwd (varchar2(30))
- seller_business_no — not null
- Field3 (seller_business_name) — null
- Field4 (seller_ceo) — null
- Field (seller_business_tel) — null
- Field2 (seller_business_tel_no) — null
- Field3 (seller_business_address) — null
- Field (seller_business_addressv) — null