ShopLingo

Tables (4)

Report (에이전트 리포트 내역)

  • report_id (REPORT_ID) — BIGSERIAL — Primary key — NOT NULL
  • user_id (USER_ID) — BIGSERIAL — Foreign key → members.id — NOT NULL
  • run_id (RUN_ID) — UUID — NOT NULL
  • input_state (INPUT_STATE) — JSONB — 입력 스테이트(Langgaph 특성)
  • output_state (OUTPUT_STATE) — JSONB
  • created_at (CREATED_AT) — TIMESTAMP — NOT NULL

members (회원)

  • id (ID) — BIGSERIAL — Primary key — NOT NULL
  • email (EMAIL) — VARCHAR(255) — NOT NULL
  • password (PASSWORD) — VARCHAR(255) — NOT NULL
  • created_at (CREATED_AT) — TIMESTAMP — NOT NULL
  • updated_at (UPDATED_AT) — TIMESTAMP — NOT NULL — 회원정보 수정 내역
  • username (USERNAME) — VARCHAR(255) — NOT NULL — 유저이름

product_descriptions (상품설명)

  • id (ID) — BIGSERIAL — Primary key — NOT NULL
  • user_id (USER_ID) — BIGSERIAL — Foreign key → members.id — NOT NULL — REFERENCES users(id) ON DELETE CASCADE
  • product_name (PRODUCT_NAME) — VARCHAR(255) — NOT NULL
  • generated_description (GENERATED_DESCRIPTION) — TEXT — NOT NULL — 상품설명 (상품명과는 다르게 제한 없는 TEXT)
  • created_at (CREATED_AT) — TIMESTAMP — NOT NULL — Auto
  • input_prompt (INPUT_PROMPT) — TEXT — NOT NULL

showcase_items (메인 노출용 상품설명)

  • id (ID) — BIGSERIAL — Primary key — NOT NULL — REFERENCES product_descriptions(id) ON DELETE CASCADE
  • product_descriptions_id (PRODUCT_DESCRIPTIONS_ID) — BIGSERIAL — Foreign key → product_descriptions.id — NOT NULL
  • displayed_at (DISPLAYED_AT) — TIMESTAMP — NOT NULL — 날짜별 정렬용