test1
Tables (30)
board_preference_statistic
- id — bigint
- basic_score — double
- board_id — bigint
- preference_score — double
- preference_type — varchar(30)
- preference_weight — int
board_statistic
- id — bigint
- basic_score — double
- board_id — bigint
- board_review_grade — decimal(3, 2)
- board_view_count — int
- board_review_count — int
- board_wish_count — int
flyway_schema_history
- installed_rank — int — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int — NOT NULL
- success — tinyint(1) — NOT NULL
food_survey
- id — bigint
- q1_diabetes — tinyint
- q1_gluten_intolerance — tinyint
- q1_lactose_intolerance — tinyint
- q1_not_applicable — tinyint
- q2_body_fat — tinyint
- q2_cholesterol — tinyint
- q2_digestive_disorder — tinyint
- q2_not_applicable — tinyint
- q2_pimples — tinyint
- q4_animal_ingredient — tinyint
- q4_diary — tinyint
- q4_egg — tinyint
- q4_fruit — tinyint
- q4_meat — tinyint
- q4_sea_food — tinyint
- member_id — bigint
- q3_bean — tinyint
- q3_egg — tinyint
- q3_flour — tinyint
- q3_milk — tinyint
- q_3_not_applicable — tinyint
- q3_peach — tinyint
- q3_peanut — tinyint
- q3_pine_nuts — tinyint
- q3_rice — tinyint
- q3_soy_milk — tinyint
- q3_sugar — tinyint
- q3_tomato — tinyint
- q3_walnuts — tinyint
- q3_white_wheat — tinyint
image
- id — bigint
- image_category — varchar(30)
- domain_id — bigint
- image_order — int
- path — varchar(255)
- created_at — datetime
- modified_at — datetime
member
- id — bigint
- email — varchar(255)
- phone — varchar(11)
- name — varchar(15)
- nickname — varchar(50)
- birth — varchar(10)
- profile — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
- provider — varchar(20)
- provider_id — varchar(50)
- sex — varchar(10)
- member_role — varchar(15) — NOT NULL
member_preference
- id — bigint
- member_id — bigint — NOT NULL
- preference_id — bigint — NOT NULL
notice
- id — bigint
- title — varchar(30)
- content — varchar(255)
- created_at — datetime(6)
preference
- id — bigint
- preference_type — varchar(50) — NOT NULL
product
- id — bigint
- product_board_id — bigint — NOT NULL
- title — varchar(50) — NOT NULL
- price — int
- category — varchar(20) — NOT NULL
- gluten_free_tag — tinyint — NOT NULL
- high_protein_tag — tinyint — NOT NULL
- sugar_free_tag — tinyint — NOT NULL
- vegan_tag — tinyint
- ketogenic_tag — tinyint — NOT NULL
- monday — tinyint — NOT NULL
- tuesday — tinyint — NOT NULL
- wednesday — tinyint — NOT NULL
- thursday — tinyint — NOT NULL
- friday — tinyint — NOT NULL
- saturday — tinyint — NOT NULL
- sunday — tinyint — NOT NULL
- order_start_date — datetime
- order_end_date — datetime
- sugars — int
- protein — int
- carbohydrates — int
- fat — int
- weight — int
- calories — int
- is_soldout — tinyint
- serving_weight — int
- stock — int — NOT NULL
product_board
- id — bigint
- store_id — bigint — NOT NULL
- title — varchar(50) — NOT NULL
- price — int — NOT NULL
- is_soldout — tinyint — NOT NULL
- purchase_url — varchar(255) — NOT NULL
- view — int — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
- wish_cnt — int
- delivery_fee — int
- free_shipping_conditions — int
- discount_rate — int
- product_info_notice_id — bigint
- discount_price — int — NOT NULL
- board_detail_id — bigint
product_detail
- id — bigint
- created_at — datetime(6)
- modified_at — datetime(6)
- content — longtext
product_img
- id — bigint
- product_board_id — bigint — NOT NULL
- url — varchar(255) — NOT NULL
- img_order — int — NOT NULL
product_info_notice
- id — bigint
- product_name — varchar(50) — NOT NULL
- food_type — varchar(255)
- manufacturer — varchar(255)
- origin_location — varchar(255)
- manufacture_date — varchar(255)
- expiration_date — varchar(255)
- storage_guide — varchar(255)
- packaging_quantity_unit — varchar(255)
- raw_material_name — varchar(255)
- nutrition_info — varchar(255)
- transgenic — varchar(255)
- customer_warning — varchar(255)
- import_food — varchar(255)
push
- id — bigint
- fcm_token — varchar(255) — NOT NULL
- member_id — bigint — NOT NULL
- product_id — bigint — NOT NULL
- push_category — varchar(255) — NOT NULL
- push_type — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)
- reservation_date — datetime
- days — varchar(255)
- is_active — tinyint
random_board
- id — bigint
- set_number — int
- random_board_id — bigint
recommendation_similar_board
- query_item — bigint — Primary key — NOT NULL
- rank — int — Primary key — NOT NULL
- recommendation_item — bigint — NOT NULL
- score — decimal(17, 16)
- recommendation_theme — varchar(255)
- model_version — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)
refresh_token
- id — bigint
- member_id — bigint — NOT NULL
- refresh_token — varchar(255) — NOT NULL
review
- id — bigint
- member_id — bigint — NOT NULL
- board_id — bigint
- badge_taste — varchar(20)
- badge_brix — varchar(20)
- badge_texture — varchar(20)
- rate — decimal(2, 1)
- content — text
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint(1)
- is_best — tinyint
review_img
- id — bigint
- review_id — bigint — NOT NULL
- url — varchar(255) — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
review_like
- id — bigint
- member_id — bigint — NOT NULL
- review_id — bigint — NOT NULL
search
- id — bigint
- member_id — bigint — NOT NULL
- is_deleted — tinyint — NOT NULL
- keyword — varchar(255) — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
segment
- id — int
- version — varchar(5) — NOT NULL
- segment — longtext — NOT NULL
- created_at — timestamp
- expired_at — timestamp
signature_agreement
- id — bigint
- member_id — bigint — NOT NULL
- name — varchar(100) — NOT NULL
- date_of_signature — datetime(6) — NOT NULL
- agreement_status — tinyint — NOT NULL
store
- id — bigint
- identifier — varchar(16) — NOT NULL
- name — varchar(255) — NOT NULL
- introduce — varchar(255)
- profile — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
test_store
- id — bigint
- identifier — varchar(16) — NOT NULL
- name — varchar(255) — NOT NULL
- introduce — varchar(255)
- profile — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
wishlist_folder
- id — bigint
- member_id — bigint — NOT NULL
- folder_name — varchar(50)
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
wishlist_product
- id — bigint
- wishlist_folder_id — bigint — NOT NULL
- product_board_id — bigint — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- member_id — bigint
wishlist_store
- id — bigint
- member_id — bigint — NOT NULL
- store_id — bigint — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — tinyint
withdrawal
- id — bigint
- member_id — bigint — NOT NULL
- reason — varchar(255)
- created_at — datetime(6)
- modified_at — datetime(6)