whateat
Tables (10)
USER_ATTENDANCE (Untitled7)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- date (Field)
- is_success (Field2)
- streak_count (Field3)
User_Quest (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- Key (Key3) — Foreign key → quest.Key — NOT NULL
- reward (Field)
- status (Field2)
- started_at (Field3)
- completed_at (Field4)
User_level (Untitled6)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- required_exp (Field)
- bagde_name (Field2)
- reword_point (Field3)
User_receipt (Untitled5)
- Key — Primary key — NOT NULL
- Key (Key3) — Foreign key → member.Key — NOT NULL
- Key (Key2) — Foreign key → receipt.Key — NOT NULL
frige_item (Untitled10)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → refrigerator.Key — NOT NULL
- Key (Key22) — Foreign key → refrigerator.Key — NOT NULL
- Key (Key3) — Foreign key → ingredient.Key — NOT NULL
- storage_type (냉동/대파/실온)
- quantity (Field)
- unit (g/ml/개)
- expiration_date (Field2)
- in_favorite (Field3)
- create_at (Field4)
ingredient (Untitled9)
- Key — Primary key — NOT NULL
- name (Field)
- default_unit (Field2)
- image_url (Field3)
member (Untitled)
- Key — Primary key — NOT NULL
- 로그인 타입 (loginType)
- level (Field)
- email (Field2)
- password (Field3)
- nickname (Field4)
- exp (Field5)
- totalPoint (Field6)
- create_at (Field7)
quest (Untitled2)
- Key — Primary key — NOT NULL
- title (Field)
- description (Field2)
- difficulty (Field3)
- exp_reward (Field4)
- point_reward (Field5)
- is_daily (Field6)
- created_at (Field7)
receipt (Untitled8)
- Key — Primary key — NOT NULL
- title (Field)
- description (Field2)
- difficult (Field3)
- thumbnail_url (Field4)
refrigerator (Untitled4)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → member.Key — NOT NULL
- name (Field)
- create_at (Field2)