편잇

테이블 (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)