final

Tables (20)

answer_post

  • answer_id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → qna_post.post_id — NOT NULL
  • created_date — datetime — NOT NULL
  • modified_date — datetime
  • answer_content — varchar — NOT NULL

cart

  • cart_id — bigint — Primary key — NOT NULL
  • period_option_id — bigint — Foreign key → period_option.period_option_id — NOT NULL
  • product_id — bigint — Foreign key → period_option.product_id — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • created_date — datetime — NOT NULL
  • cart_quantity — int — NOT NULL

category

  • category_id — bigint — Primary key — NOT NULL
  • category_name — varchar — NOT NULL
  • parent_id — int

image

  • image_id — bigint — Primary key — NOT NULL
  • image_name — varchar
  • image_byte — bigint — NOT NULL
  • image_path — varchar
  • image_format — varchar
  • image_original_name — varchar
  • dype — varchar

member

  • member_id — bigint — Primary key — NOT NULL
  • created_date — datetime — NOT NULL
  • modified_date — datetime
  • member_birth — varchar — NOT NULL
  • member_delete_check — boolean — NOT NULL
  • member_email — varchar — NOT NULL
  • member_gender — varchar — NOT NULL
  • member_grade — varchar — NOT NULL
  • member_name — varchar — NOT NULL
  • member_nickname — varchar — NOT NULL
  • member_pw — varchar — NOT NULL
  • member_phone — varchar — NOT NULL
  • member_email_agree — boolean — NOT NULL
  • member_sms_agree — boolean — NOT NULL
  • is_non_members — boolean — NOT NULL
  • survey_id — bigint

member_hobby

  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • member_hobby — varchar

member_image

  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • image_id — bigint — Foreign key → image.image_id — NOT NULL

member_roles

  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • roles — varchar — NOT NULL

orders

  • order_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • created_date — datetime — NOT NULL
  • modified_date — datetime
  • order_status — varchar — NOT NULL
  • payment_method — varchar — NOT NULL

period_option

  • period_option_id — bigint — Primary key — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • minimum_quantity — int — NOT NULL
  • maximum_quantity — int — NOT NULL
  • option_name — varchar — NOT NULL
  • period — int — NOT NULL
  • period_option_status — varchar — NOT NULL
  • sold_quantity — int — NOT NULL
  • stat_airline — varchar — NOT NULL
  • end_airline — varchar — NOT NULL
  • start_detail — varchar

post

  • post_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • post_title — varchar — NOT NULL
  • post_content — varchar
  • post_type — varchar — NOT NULL
  • created_date — datetime
  • modified_date — datetime
  • is_canceled — boolean

product

  • product_id — bigint — Primary key — NOT NULL
  • created_date — datetime — NOT NULL
  • product_name — varchar — NOT NULL
  • product_content — varchar
  • proiduct_price — int — NOT NULL
  • content_detail — varchar
  • product_status — varchar — NOT NULL
  • wishlist_count — int

product_category

  • product_category_id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → category.category_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL

product_image

  • image_id — bigint — Foreign key → image.image_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL

purchased_product

  • purchased_product_id — bigint — Primary key — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL
  • order_id — bigint — Foreign key → orders.order_id — NOT NULL
  • member_id — bigint — Foreign key → orders.member_id — NOT NULL
  • purchased_product_thumbnail — int — NOT NULL
  • purchased_product_name — varchar — NOT NULL
  • purchased_product_price — int — NOT NULL
  • option_name — varchar — NOT NULL
  • period — int — NOT NULL
  • purchased_product_quantity — int — NOT NULL
  • start)date — varchar — NOT NULL
  • end_date — datetime — NOT NULL

qna_post

  • post_id — bigint — Foreign key → post.post_id — NOT NULL
  • qna_status — varchar — NOT NULL
  • qna_inquiry_type — VARCHAR(255) — NOT NULL

qna_product_post

  • purchased_product_id — bigint — Foreign key → purchased_product.purchased_product_id — NOT NULL
  • post_id — bigint — Foreign key → qna_post.post_id — NOT NULL

review_post

  • post_id — bigint — Foreign key → post.post_id — NOT NULL
  • purchased_product_id — bigint — Foreign key → purchased_product.purchased_product_id — NOT NULL
  • review_scope — int

survey

  • survey_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • survey_hobby — varchar — NOT NULL
  • survey_group — varchar — NOT NULL
  • survey_religion — varchar — NOT NULL
  • survey_season — varchar — NOT NULL
  • survey_companion — varchar — NOT NULL

wishlist

  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL