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 — 날짜별 정렬용