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)