레시피공유사이트
테이블 (8)
Category
- korean — str
- chinese — str
- japanese — str
- western — str
- vegeterian — str
- other — str
Information
- serving — int
- time — int
- level — int
SequenceItem
- picture — str
- description — str
recipe
- recipe_id — UUID
- recipe_title — str
- recipe_thumbnail — str
- recipe_description — str
- recipe_category — List[Category]
- recipe_info — Information
- recipe_ingredients — List[Ingredients]
- recipe_sequence — List[SequenceItem]
- recipe_tip — str
- user_id — str
recipe_comments
- comment_id — INT
- recipe_id — INT
- user_id — VARCHAR(255)
- comment_text — TEXT
- created_at — DATETIME
recipe_ratings
- recipe_id — INT
- user_id — VARCHAR(255)
- likes — INT
users
- user_id — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- created_at — DATETIME