semi
Tables (7)
cart
- cart_no — number
- member_id — references — NOT NULL
- product_no — references — NOT NULL
- option_no — references — NOT NULL
- amount — number — NOT NULL
- created_at — timestamp — NOT NULL
member
- member_id — varchar2(20)
- member_pw — varchar2(16) — NOT NULL
- member_nickname — varchar2(30) — NOT NULL
- member_birth — char(10)
- member_contact — char(11)
- member_email — varchar2(60) — NOT NULL
- member_level — varchar2(12) — NOT NULL
- member_point — number — NOT NULL
- member_post — varchar2(6)
- member_address1 — varchar2(300)
- member_address2 — varchar2(300)
- member_join — timestamp — NOT NULL
- member_login — timestamp
- member_change — timestamp
order_detail
- order_detail_no — number
- order_no — references — NOT NULL
- product_no — references — NOT NULL
- option_no — references — NOT NULL
- amount — number — NOT NULL
- price_per_item — number — NOT NULL
orders
- orders_no — number
- orders_id — references
- orders_totalPrice — number
- orders_recipient — varchar2(60)
- orders_recipientContact — char(11)
- orders_shippingPost — varchar(6)
- orders_shippingAddress1 — varchar(300)
- orders_shippingAddress2 — varchar(300)
- orders_status — varchar2(60)
product
- product_no — number
- product_name — varchar2(90) — NOT NULL
- product_price — number — NOT NULL
- product_content — varchar2(4000) — NOT NULL
product_option
- option_no — number
- product_no — references — NOT NULL
- option_name — varchar2(30) — NOT NULL
- option_value — varchar2(30) — NOT NULL
- option_amount — number — NOT NULL
review
- review_no — number
- product_no — references — NOT NULL
- member_id — references — NOT NULL
- review_content — varchar2(4000) — NOT NULL
- review_rating — number(1) — NOT NULL
- review_created_at — timestamp — NOT NULL