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