KITRI ST Shop

Tables (11)

admin

  • admin_id — VARCHAR2(30) — Primary key — NOT NULL
  • admin_password — VARCHAR2(256) — NOT NULL
  • admin_authlevel — VARCHAR2(10)
  • admin_otpkey — VARCHAR2(50)
  • admin_phone — VARCHAR2(20)
  • admin_name — VARCHAR2(20)
  • admin_address — VARCHAR2(50)
  • admin_active — NUMBER(2)

auction

  • auction_id — NUMBER(10) — Primary key — NOT NULL
  • start_price — NUMBER(10)
  • end_price — NUMBER(10)
  • start_time — DATE
  • end_time — DATE
  • product_id — VARCHAR2(20) — Foreign key → product.product_id — NOT NULL
  • user_id — VARCHAR2(20)

cs

  • cs_seq — NUMBER(10) — Primary key — NOT NULL
  • cs_title — VARCHAR2(20)
  • cs_contents — VARCHAR2(500)
  • cs_category — VARCHAR2(20)
  • cs_writer — VARCHAR2(20)
  • cs_comments_writer — VARCHAR2(20)
  • cs_comments_contents — VARCHAR2(500)
  • user_id — VARCHAR2(20) — Foreign key → shopuser.user_id — NOT NULL
  • product_id — VARCHAR2(20)
  • cs_date — DATE
  • cs_comments_date — DATE

discount

  • discount_id — NUMBER(10) — Primary key — NOT NULL
  • discount_rate — NUMBER(5)
  • user_id — VARCHAR2(20) — Foreign key → shopuser.user_id — NOT NULL
  • discount_useage — VARCHAR2(20)
  • dicount_activedate — DATE

faq

  • faq_seq — NUMBER(10) — Primary key — NOT NULL
  • faq_q — VARCHAR2(20)
  • faq_a — VARCHAR2(100)

group_purchase

  • group_purchase_id — NUMBER(10) — Primary key — NOT NULL
  • group_purchase_date — DATE
  • product_id — VARCHAR2(20) — Foreign key → product.product_id — NOT NULL
  • user_id — VARCHAR2(20)

notice

  • notice_seq — NUMBER(10) — Primary key — NOT NULL
  • admin_id — VARCHAR2(30) — Foreign key → admin.admin_id — NOT NULL
  • notice_title — VARCHAR2(30)
  • notice_contents — VARCHAR2(500)

product

  • product_id — VARCHAR2(20) — Primary key — NOT NULL
  • product_detail — VARCHAR2(20)
  • product_price — NUMBER(5)
  • product_balance — VARCHAR2(20)
  • product_sellcount — VARCHAR2(20)
  • product_category — VARCHAR2(20)
  • product_brand — VARCHAR2(20)
  • product_name — VARCHAR2(20)
  • product_image — VARCHAR2(50)
  • product_release — DATE
  • sales_persent — NUMBER
  • sales_date — DATE

review

  • review_seq — NUMBER(10) — Primary key — NOT NULL
  • review_title — VARCHAR2(20)
  • review_contents — VARCHAR2(500)
  • review_recommend — NUMBER(5)
  • product_id — VARCHAR2(20) — Foreign key → product.product_id — NOT NULL
  • user_id — VARCHAR2(20) — Foreign key → shopuser.user_id — NOT NULL

shoporder

  • order_id — NUMBER(10) — Primary key — NOT NULL
  • order_name — VARCHAR2(20)
  • order_balance — NUMBER(10)
  • order_price — NUMBER(10)
  • order_payment — VARCHAR2(20)
  • product_id — VARCHAR2(20)
  • user_id — VARCHAR2(20) — Foreign key → shopuser.user_id — NOT NULL
  • order_date — DATE
  • shipment_address — VARCHAR2(50)
  • shipment_zipcode — VARCHAR2(10)
  • order_invoice — CHAR(18)

shopuser

  • user_id — VARCHAR2(20) — Primary key — NOT NULL
  • user_password — VARCHAR2(20)
  • user_email — VARCHAR2(20)
  • user_address — VARCHAR2(50)
  • user_name — VARCHAR2(20)
  • user_grade — NUMBER(5)
  • user_joindate — DATE
  • user_token — VARCHAR2(50)
  • user_phone — VARCHAR2(20)
  • user_stack — NUMBER(20)