poster4j
Tables (12)
canceled_order
- order_id — NUMBER — Foreign key → order_detail.order_id — NOT NULL
- product_id — NUMBER — Foreign key → order_detail.product_id — NOT NULL
- option_size — VARCHAR2(50) — Foreign key → order_detail.option_size — NOT NULL
- option_frame — VARCHAR2(50) — Foreign key → order_detail.option_frame — NOT NULL
- order_cancel_category — VARCHAR2(20) — NOT NULL
- order_cancel_reason — VARCHAR2(100) — NOT NULL
- order_cancel_req_date — DATE — NOT NULL
- order_cancel_cmptn_date — DATE — NOT NULL
cart
- option_size — VARCHAR2(50) — Primary key — NOT NULL
- option_frame — VARCHAR2(50) — Primary key — NOT NULL
- customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- cart_product_quantity — NUMBER — NOT NULL
- cart_product_checked — VARCHAR2(20) — NOT NULL
customer
- customer_id — VARCHAR2(20) — Primary key — NOT NULL
- customer_password — VARCHAR2(100) — NOT NULL
- customer_name — VARCHAR2(30) — NOT NULL
- customer_telno — VARCHAR2(30) — NOT NULL
- customer_email — VARCHAR2(50) — NOT NULL
- customer_term_agree — VARCHAR2(20)
- customer_info_agree — VARCHAR2(20)
- customer_sms_agree — VARCHAR2(20)
- customer_email_agree — VARCHAR2(20)
- customer_enabled — VARCHAR2(20) — NOT NULL
order_detail
- option_size — VARCHAR2(50) — Primary key — NOT NULL
- option_frame — VARCHAR2(50) — Primary key — NOT NULL
- order_id — NUMBER — Foreign key → order_t.order_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- order_detail_quantity — NUMBER — NOT NULL
- order_detail_price — NUMBER — NOT NULL
- order_detail_status — VARCHAR2(20) — NOT NULL
- order_dl_cmptn_date — DATE
order_t
- order_id — NUMBER — Primary key — NOT NULL
- customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
- receiver_id — NUMBER — Foreign key → receiver.receiver_id — NOT NULL
- order_date — DATE — NOT NULL
- order_settlement_method — VARCHAR2(30) — NOT NULL
- order_delivery_demand — VARCHAR2(100)
product
- product_id — NUMBER — Primary key — NOT NULL
- product_name — VARCHAR2(50) — NOT NULL
- product_price — NUMBER — NOT NULL
- product_discount_rate — FLOAT — NOT NULL
- product_theme — VARCHAR2(20) — NOT NULL
- product_artist — VARCHAR2(20) — NOT NULL
- product_detail — VARCHAR2(600)
- product_enabled — VARCHAR2(20) — NOT NULL
product_image
- product_image_name — VARCHAR2(20) — Primary key — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- product_image_ctgry — VARCHAR2(20) — NOT NULL
- product_image_type — VARCHAR2(30) — NOT NULL
- product_image_source — BLOB — NOT NULL
product_inquiry
- product_inquiry_id — NUMBER — Primary key — NOT NULL
- customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- product_inquiry_content — VARCHAR2(200) — NOT NULL
- product_inquiry_date — DATE — NOT NULL
- product_inquiry_answered — VARCHAR2(20) — NOT NULL
product_inquiry_answer
- product_inquiry_id — NUMBER — Foreign key → product_inquiry.product_inquiry_id — NOT NULL
- product_inquiry_answer_content — VARCHAR2(200) — NOT NULL
- product_inquriy_answer_date — DATE — NOT NULL
receiver
- receiver_id — NUMBER — Primary key — NOT NULL
- customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
- receiver_name — VARCHAR2(30) — NOT NULL
- receiver_zip — VARCHAR2(10) — NOT NULL
- receiver_address — VARCHAR2(50) — NOT NULL
- receiver_address_detail — VARCHAR2(50)
- receiver_address_type — VARCHAR2(20) — NOT NULL
- receiver_telno — VARCHAR2(20) — NOT NULL
- receiver_person_name — VARCHAR2(20) — NOT NULL
- receiver_enabled — VARCHAR2(20) — NOT NULL
review
- order_id — NUMBER — Foreign key → order_detail.order_id — NOT NULL
- product_id — NUMBER — Foreign key → order_detail.product_id — NOT NULL
- option_size — VARCHAR2(50) — Foreign key → order_detail.option_size — NOT NULL
- option_frame — VARCHAR2(50) — Foreign key → order_detail.option_frame — NOT NULL
- review_star_rating — NUMBER — NOT NULL
- review_content — VARCHAR2(600) — NOT NULL
- review_written_date — DATE — NOT NULL
review_image
- review_image_id — NUMBER — Primary key — NOT NULL
- order_id — NUMBER — Foreign key → review.order_id — NOT NULL
- product_id — NUMBER — Foreign key → review.product_id — NOT NULL
- option_size — VARCHAR2(50) — Foreign key → review.option_size — NOT NULL
- option_frame — VARCHAR2(50) — Foreign key → review.option_frame — NOT NULL
- review_image_name — VARCHAR2(100) — NOT NULL
- review_image_type — VARCHAR2(30) — NOT NULL
- review_image_source — BLOB — NOT NULL