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