벨루가브루어리
테이블 (15)
aromas
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name_ko — VARCHAR(64) — NOT NULL
- name_en — VARCHAR(64) — NOT NULL
- img_url — VARCHAR(2048)
beverage_aroma
- id — INT
- beverage_id — INT — NOT NULL
- aroma_id — INT — NOT NULL
beverage_base
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name_ko — VARCHAR(255) — NOT NULL
- name_origin — VARCHAR(255) — NOT NULL
- beverage_style_id — INT — NOT NULL
beverage_palette
- id — INT
- beverage_id — INT — NOT NULL
- palette_id — INT — NOT NULL
beverage_styles
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- beverage_type_id — INT — NOT NULL
- name — VARCHAR(128) — NOT NULL
beverage_tag
- id — INT
- beverage_id — INT — NOT NULL
- tag_id — INT — NOT NULL
beverage_types
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name — VARCHAR(40) — NOT NULL
beverages
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- beverage_base_id — INT — NOT NULL
- country_id — INT — NOT NULL
- img_url — VARCHAR(2048)
- container_type — VARCHAR(40) — NOT NULL
- volume — INT — NOT NULL
- abv — DECIMAL(4,2) — NOT NULL
- avg_retail_price — DECIMAL(10,2) — NOT NULL
- avg_consumer_price — DECIMAL(10,2) — NOT NULL
- description — TEXT
- seller_id — INT — NOT NULL
- manufacturer_id — INT — NOT NULL
- view_count — INT — NOT NULL
- review_count — INT — NOT NULL
countries
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name — VARCHAR(64) — NOT NULL
palettes
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name — VARCHAR(64) — NOT NULL
- level — SMALLINT — NOT NULL
- left_label — VARCHAR(40) — NOT NULL
- right_label — VARCHAR(40) — NOT NULL
review_replies
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- review_id — INT — NOT NULL
- writer_id — INT — NOT NULL
- content — TEXT — NOT NULL
reviews
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- beverage_id — INT — NOT NULL
- writer_id — INT — NOT NULL
- rating — SMALLINT — NOT NULL
- content — TEXT — NOT NULL
- order_id — VARCHAR(255) — NOT NULL
tags
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name — VARCHAR(128) — NOT NULL
user_types
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- name — VARCHAR(40) — NOT NULL
- is_seller — BOOLEAN — NOT NULL
users
- id — INT
- created_at — DATETIME
- updated_at — DATETIME
- user_type_id — INT
- business_number — VARCHAR(10) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- company_name — VARCHAR(128) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- address_detail — VARCHAR(100)
- join_purpose — VARCHAR(128) — NOT NULL
- marketing_opt_in — BOOLEAN — NOT NULL