ERD

Tables (14)

preference

  • id — bigint
  • preference_type — varchar(50) — NOT NULL

productInfoNotice

  • id — bigint
  • productName — varchar(50) — NOT NULL
  • foodType — varchar(255)
  • manufacturer — varchar(255)
  • originLocation — varchar(255)
  • manufactureDate — varchar(255)
  • expirationDate — varchar(255)
  • storageGuide — varchar(255)
  • packagingQuantityUnit — varchar(255)
  • rawMaterialName — varchar(255)
  • nutritionInfo — varchar(255)
  • transgenic — varchar(255)
  • customerWarning — varchar(255)
  • importFood — varchar(255)

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

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

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)