테이스팅 노트
테이블 (12)
Alcohol (Untitled2)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- name_kor (Field7)
- category (Field2)
- abv (Field3)
- origin (Field4)
- region (Field8)
- vintage (Field9)
- created_at (Field5)
- updated_at (Field6)
Alcohol_alias (Untitled8)
- id (Key) — 기본 키 — NOT NULL
- alcohol_id (Key2) — 외래 키 → Alcohol.id — NOT NULL
- alias (Field)
- created_at (Field2)
- updated_at (Field3)
Flavor_suggestion (Untitled10)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- created_at (Field2)
- updated_at (Field3)
Like (Untitled5)
- id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → User.id — NOT NULL
- note_id (Key3) — 외래 키 → Note.id — NOT NULL
- type (Field3)
- created_at (Field)
- updated_at (Field2)
Note (Untitled3)
- id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → User.id — NOT NULL
- alcohol_id (Key3) — 외래 키 → Alcohol.id — NOT NULL
- title (Field3)
- pairing (Field6)
- rating (Field7)
- description (Field8)
- is_public (Field9)
- status (Field2)
- drank_at (Field4)
- location (Field5)
- created_at (Field10)
- updated_at (Field11)
NoteImage (Untitled4)
- id (Key) — 기본 키 — NOT NULL
- note_id (Key2) — 외래 키 → Note.id — NOT NULL
- image_url (Field2)
- created_at (Field)
- updated_at (Field3)
NoteTag (Untitled7)
- id (Key) — 기본 키 — NOT NULL
- note_id (Key2) — 외래 키 → Note.id — NOT NULL
- tag_id (Key3) — 외래 키 → Tag.id — NOT NULL
- created_at (Field)
- updated_at (Field2)
Note_flavor (Untitled9)
- id (Key) — 기본 키 — NOT NULL
- note_id (Key2) — 외래 키 → Note.id — NOT NULL
- flavor_id (Key3) — 외래 키 → Flavor_suggestion.id — NOT NULL
- type (Field)
- created_at (Field3)
- updated_at (Field4)
Refresh_token (Untitled12)
- id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → User.id — NOT NULL
- token (Field)
- expires_at (Field2)
- created_at (Field3)
- updated_at (Field4)
Report (Untitled11)
- id (Key) — 기본 키 — NOT NULL
- reporter_id (Key2) — 외래 키 → User.id — NOT NULL
- note_id (Key3) — 외래 키 → Note.id — NOT NULL
- reason (Field)
- reason_detail (Field2)
- status (Field3)
- created_at (Field4)
- updated_at (Field5)
Tag (Untitled6)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- count (Field4)
- created_at (Field2)
- updated_at (Field3)
User (Untitled)
- id (Key) — 기본 키 — NOT NULL
- email (Field2)
- password (Field)
- nickname (Field4)
- birth_date (Field3)
- profile_img_url (Field6)
- provider (Field8)
- provider_id (Field9)
- deleted_at (Field10)
- created_at (Field5)
- updated_at (Field7)