cocktail
Tables (6)
cocktail (Untitled)
- id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.id — NOT NULL — member id
- name (Field) — var — NOT NULL — 칵테일 이름
- description (Field2) — NOT NULL — 칵테일 설명
- type (Field3) — NOT NULL — 롱 숏 타입
- created_date (Field4) — auditing
inner_liquid (Untitled3)
- id (Key) — Primary key — NOT NULL
- liquid_id (Key2) — Foreign key → liquid.id — NOT NULL — liquid id
- cocktail_id (Key3) — Foreign key → cocktail.id — NOT NULL — cocktail id
- amount (Field) — 내용물 용량
like (Untitled5)
- id (Key) — Primary key — NOT NULL
- cocktail_id (Key2) — Foreign key → cocktail.id — NOT NULL — 칵테일
- member_id (Key3) — Foreign key → member.id — NOT NULL — 멤버
- created_date (Field) — auditing
liquid (Untitled2)
- id (Key) — Primary key — NOT NULL
- name (Field) — NOT NULL — 내용물 이름
- alchol_level (Field2) — 내용물 도수
- description (Field3) — 내용물 설명
- company (Field4) — 내용물 회사
- price (Field5) — 내용물 가격
- type (Field6) — 기주인지 아닌지
- created_date (Field7) — auditing
member (Untitled4)
- id (Key) — Primary key — NOT NULL
- name (Field) — 이름겸 닉네임
- email (Field2) — 이메일
- password (Field3) — 비밀번호
- intro (Field4) — 자기소개
- role (Field5) — 역할
- created_date (Field6) — auitding