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