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