편잇
테이블 (7)
ai_recipe (Untitled2)
- post_id (Primary Key) — LONG — 기본 키 — NOT NULL
- user_id (Primary Key2) — LONG — 외래 키 → user.user_id — NOT NULL
- post_name (Field) — VARCHAR(50)
- post_context (Field2) — VARCHAR(5000)
- post_image (Field3) — VARCHAR(500)
chat (Untitled7)
- chat_id (Primary Key) — LONG — 기본 키 — NOT NULL
- user_id (Primary Key2) — LONG — 외래 키 → user.user_id — NOT NULL
- chat_title (Field) — VARCHAR(50)
chat_context (Untitled6)
- cc_id (Primary Key) — LONG — 기본 키 — NOT NULL
- chat_id (Primary Key2) — LONG — 외래 키 → chat.chat_id — NOT NULL
- chat_context (Field) — VARCHAR(5000)
- timestamp (Field3) — DATE
- type (Field2) — Enum{'user' , 'ai'}
mark_recipe (Untitled3)
- mark_id (Primary Key) — LONG — 기본 키 — NOT NULL
- user_id (Primary Key2) — LONG — 외래 키 → user.user_id — NOT NULL
- mark_name (Field) — VARCHAR(50)
- mark_content (Field2) — VARCHAR(5000)
- mark_image (Field3) — VARCHAR(500)
prefer_tag (Untitled5)
- user_id (Primary Key) — LONG — 외래 키 → user.user_id — NOT NULL
- tag_id (Primary Key2) — LONG — 외래 키 → tag.tag_id — NOT NULL
tag (Untitled4)
- tag_id (Primary Key) — LONG — 기본 키 — NOT NULL
- tag_name (Field) — VARCHAR(30)
user (Untitled)
- user_id (Primary Key) — LONG — 기본 키 — NOT NULL
- user_name (Field) — VARCHAR(30)
- email (Field3) — VARCHAR(30)
- pssword (Field2) — VARCHAR(20)