Soolae
Tables (8)
banner
- id — BIGINT(19) — Primary key — NOT NULL
- file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- src — TEXT
- order — INT(10) — NOT NULL
cocktail
- id — BIGINT(19) — Primary key — NOT NULL — 아이디
- file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
- user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
- cocktail_name — VARCHAR(50) — NOT NULL — 이름' COLLATE 'utf8mb4_general_ci
- proof — FLOAT — NOT NULL — 도수
- glass — VARCHAR(50) — NOT NULL — 잔' COLLATE 'utf8mb4_general_ci
- method — VARCHAR(50) — NOT NULL — 기법' COLLATE 'utf8mb4_general_ci
- garnish — VARCHAR(50) — 가니시' COLLATE 'utf8mb4_general_ci
- description — TEXT
- status — VARCHAR(50) — NOT NULL
cocktail_ingredient
- id — BIGINT(19) — Primary key — NOT NULL
- cocktail_id — BIGINT(19) — Foreign key → cocktail.id — NOT NULL — 아이디
- ingredient_id — BIGINT(19) — Foreign key → ingredient.id — NOT NULL
- volume — DOUBLE — NOT NULL
- unit — VARCHAR(100) — NOT NULL
comment
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
- target_user — BIGINT(19)
- content — VARCHAR(500)
- ref_category — VARCHAR(200)
- created_at — DATETIME
- deleted — BOOLEAN
- comment_group — NUMBER
files
- id — BIGINT(19) — Primary key — NOT NULL
- 업로더 (uploader) — BIGINT(19) — Foreign key → user.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(2048) — NOT NULL
- file_size — BIGINT(19)
- file_type — VARCHAR(200)
- created_at — DATETIME — NOT NULL
ingredient
- id — BIGINT(19) — Primary key — NOT NULL
- file_id — BIGINT(19) — Foreign key → files.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- en_name — VARCHAR(100)
- category — VARCHAR(100) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
- INDEX — `FK_ingredient_files`
oauth_user (간편로그인 유저)
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT(19) — Foreign key → user.id — NOT NULL
- email — VARCHAR(200)
- domain — VARCHAR(100)
user
- id — BIGINT(19) — Primary key — NOT NULL
- nick_name — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- email — VARCHAR(100) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- login_method — VARCHAR(50)