Tobakii
Tables (12)
cart
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- cart_count — NUMBER(2) — NOT NULL
category
- category_name — VARCHAR2(100 BYTE) — Primary key — NOT NULL
center_image
- image_original_name — VARCHAR2(50 BYTE) — NOT NULL
- image_type — VARCHAR2(50 BYTE) — NOT NULL
- image_data — BLOB — NOT NULL
- helpdesk_id — NUMBER — Foreign key → helpdesk.helpdesk_id
- notice_id — NUMBER — Foreign key → notice.notice_id
- product_review_id — NUMBER — Foreign key → product_review.product_review_id
comment
- comment_id — NUMBER — Primary key — NOT NULL
- comment_content — VARCHAR2(1000 BYTE)
- comment_datetime — TIMESTAMP — NOT NULL
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
- notice_id — NUMBER — Foreign key → notice.notice_id
- helpdesk_id — NUMBER — Foreign key → helpdesk.helpdesk_id
helpdesk
- helpdesk_id — NUMBER — Primary key — NOT NULL
- helpdesk_title — VARCHAR2(300 BYTE) — NOT NULL
- helpdesk_content — CLOB
- helpdesk_datetime — TIMESTAMP — NOT NULL
- helpdesk_views — NUMBER — NOT NULL
- lock_state — NUMBER(1) — NOT NULL
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
member
- member_id — VARCHAR2(12 BYTE) — Primary key — NOT NULL
- member_name — VARCHAR2(15 BYTE) — NOT NULL
- member_password — VARCHAR2(200 BYTE) — NOT NULL
- member_birthday — VARCHAR2(8 BYTE) — NOT NULL
- member_email — VARCHAR2(30 BYTE) — NOT NULL
- post_num — NUMBER(5) — NOT NULL
- address — VARCHAR2(100 BYTE) — NOT NULL
- address_detail — VARCHAR2(50 BYTE)
- phone_num — VARCHAR2(11 BYTE) — NOT NULL
- member_question — NUMBER(2) — NOT NULL
- member_answer — VARCHAR2(30 BYTE) — NOT NULL
- member_role — VARCHAR2(20 BYTE) — NOT NULL
- member_enable — NUMBER(1) — NOT NULL
notice
- notice_id — NUMBER — Primary key — NOT NULL
- notice_title — VARCHAR2(300 BYTE) — NOT NULL
- notice_datetime — TIMESTAMP — NOT NULL
- notice_content — CLOB — NOT NULL
- notice_views — NUMBER — NOT NULL
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
order
- order_number — NUMBER — Primary key — NOT NULL
- order_date — TIMESTAMP — NOT NULL
- order_memo — VARCHAR2(300 BYTE)
- delivery_num — NUMBER(12) — NOT NULL
- delivery_post_num — NUMBER(5) — NOT NULL
- delivery_address — VARCHAR2(100 BYTE) — NOT NULL
- delivery_address_detail — VARCHAR2(50 BYTE)
- receiver_name — VARCHAR2(15 BYTE) — NOT NULL
- receiver_phone_num — VARCHAR2(11 BYTE) — NOT NULL
- delivery_memo — VARCHAR2(100 BYTE)
- delivery_price — NUMBER — NOT NULL
- delivery_status — VARCHAR2(100 BYTE) — NOT NULL
- order_total_price — NUMBER — NOT NULL
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
order_product
- order_number — NUMBER — Foreign key → order.order_number — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- order_product_count — NUMBER — NOT NULL
- order_product_price — NUMBER — NOT NULL
product
- product_id — NUMBER — Primary key — NOT NULL
- product_name — VARCHAR2(100 BYTE) — NOT NULL
- product_price — NUMBER — NOT NULL
- product_datetime — TIMESTAMP — NOT NULL
- product_detail — CLOB
- product_state — VARCHAR2(100 BYTE) — NOT NULL
- product_stock — NUMBER(3) — NOT NULL
- product_recom — NUMBER(1) — NOT NULL
- category_name — VARCHAR2(100 BYTE) — Foreign key → category.category_name — NOT NULL
- product_new — NUMBER(1) — NOT NULL
- product_best — NUMBER(1) — NOT NULL
product_image
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- product_usecase — VARCHAR2(20 BYTE) — NOT NULL
- image_original_name — VARCHAR2(50 BYTE) — NOT NULL
- image_type — VARCHAR2(50 BYTE) — NOT NULL
- image_data — BLOB — NOT NULL
product_review
- product_review_id — NUMBER — Primary key — NOT NULL
- review_title — VARCHAR2(300 BYTE) — NOT NULL
- review_content — CLOB
- review_point — NUMBER(1) — NOT NULL
- review_views — NUMBER — NOT NULL
- review_date — TIMESTAMP — NOT NULL
- member_id — VARCHAR2(12 BYTE) — Foreign key → member.member_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL