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)