k404Cookey
Tables (11)
comment (의견)
- id (Key) — BIGINT — Primary key — NOT NULL
- created_datd (Field) — DATETIME(6)
- modified_date (Field2) — DATETIME(6(
- content (Field3) — VARCHAR(255)
- image_url (Field4) — VARCHAR(255)
- parent_id (Field5) — BIGINT
- recipe_id (Field6) — BIGINT — NOT NULL
- user_id (Field7) — BIGINT — NOT NULL
ingredient (재료)
- id (Key) — BIGINT — Primary key — NOT NULL
- is_sub (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- recipe_id (Field3) — BIGINT — NOT NULL
label (라벨)
- id (Key) — BIGINT — Primary key — NOT NULL
- created_date (Field) — DATETIME(6)
- modified_date (Field2) — DATETIME(6)
- recipe_id (Field3) — BIGINT — NOT NULL
- user_id (Field4) — BIGINT — NOT NULL
rating (평점)
- id (Key) — BIGINT — Primary key — NOT NULL
- created_date (Field) — DATETIME(6)
- modified_date (Field2) — DATETIME(6)
- star (Field3) — DOUBLE — NOT NULL
- recipe_id (Field4) — BIGINT — NOT NULL
- Field6
recipe (레시피)
- id (Key) — BIGINT — Primary key — NOT NULL
- created_date (Field) — DATETIME(6)
- modified_date (Field2) — DATETIME(6)
- description (Field3) — VARCHAR(255)
- star_count (Field4) — DOUBLE — NOT NULL
- step (Field5) — INT — NOT NULL
- thumbnail (Field6) — VARCHAR(255)
- time (Field7) — INT — NOT NULL
- title (Field8) — VARCHAR(255)
- view_count (Field9) — INT — NOT NULL
- wish_count (Field10) — INT — NOT NULL
- pid (Field11) — BIGINT
- user_id (Field12) — BIGINT — NOT NULL
recipe_theme (레시피주제)
- id (Key) — BIGINT — Primary key — NOT NULL
- recipe_id (Field) — BIGINT — NOT NULL
- theme_id (Field2) — NOT NULL
step (단계)
- id (Key) — BIGINT — Primary key — NOT NULL
- description (Field) — VARCHAR(255)
- image_url (Field2) — VARCHAR(255)
- sequence (Field3) — INT — NOT NULL
- recipe_id (Field4) — BIGINT — NOT NULL
theme (주제)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(255)
user (유저)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255)
- image_url (Field2) — VARCHAR(255)
- name (Field3) — VARCHAR(255)
user_follow (유저 즐겨찾기)
- follower_id (Key) — BIGINT — Primary key — NOT NULL
- following_id (Key2) — BIGINT — Primary key — NOT NULL
- follower_alarm (Field) — INT
- following_alarm (Field2) — INT
user_roles (유저 역할)
- user_id (Field) — BIGINT — NOT NULL
- roles (Field2) — VARCHAR(255)