DIDIM

Tables (7)

applications

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • program_id — BIGINT — NOT NULL
  • generated_content — JSONB
  • file_url — TEXT — 생성된
  • created_at — TIMESTAMP
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

assessment_logs

  • ID (id) — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • input_data — JSONB
  • gemini_analysis — JSONB — AI가
  • created_at — TIMESTAMP
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

product_welfare_relations

  • ID (id) — UUID — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • program_id — BIGINT — NOT NULL
  • official_code — VARCHAR(100)
  • price_limit — INTEGER — 해당
  • Key — UUID — Foreign key → welfare_programs.Key — NOT NULL
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

products

  • ID (id) — UUID — Primary key — NOT NULL
  • name — VARCHAR(255)
  • domain — VARCHAR(50)
  • category — VARCHAR(100)
  • market_price — INTEGER — 일반
  • purchase_link — VARCHAR(2000)
  • specs — VARCHAR(2000) — 제품
  • tags — VARCHAR(2000) — AI
  • is_active — VARCHAR(1) — 활성
  • ID (id2) — UUID — Foreign key → product_welfare_relations.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → users.ID — NOT NULL
  • ID (id4) — UUID — Foreign key → recommendations.ID — NOT NULL

recommendations

  • ID (id) — UUID — Primary key — NOT NULL
  • log_id — UUID — NOT NULL
  • product_id — BIGINT — NOT NULL
  • is_clicked — BOOLEAN
  • click_type — VARCHAR(50)
  • created_at — TIMESTAMP
  • ID (id2) — UUID — Foreign key → users.ID — NOT NULL

users

  • ID (id) — UUID — Primary key — NOT NULL
  • clerk_user_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • birth_year — INTEGER — 나이
  • occupation — VARCHAR(50) — 직업(student
  • disability_info — JSONB — 장애
  • is_veteran — BOOLEAN
  • ltc_grade — INTEGER — 장기요양등급
  • created_at — TIMESTAMP

welfare_programs

  • Key — UUID — Primary key — NOT NULL
  • ministry — VARCHAR(100) — NOT NULL
  • program_name — VARCHAR(255) — NOT NULL
  • target_criteria — JSONB — NOT NULL — 자격
  • subsidy_limit — INTEGER — 지원
  • form_template_path — VARCHAR(500) — 신청서
  • ID (id2) — UUID — Foreign key → assessment_logs.ID — NOT NULL
  • ID (id3) — UUID — Foreign key → users.ID — NOT NULL