cocktail

Tables (6)

chat (Untitled6)

    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