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)