test
Tables (22)
ai_appraisal_results
- id — serial — Primary key — NOT NULL
- appraisal_id — integer — Foreign key → online_appraisals.id — NOT NULL
- ai_status — integer — NOT NULL
- ai_point — varchar(50)
- note — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
alembic_version
- version_num — varchar(255) — Primary key — NOT NULL
apple_webhook_events
- id — serial — Primary key — NOT NULL
- notification_uuid — varchar(255) — NOT NULL
- notification_type — varchar(100) — NOT NULL
- subtype — varchar(100)
- transaction_id — varchar(150)
- original_transaction_id — varchar(150)
- matched_order_id — integer — Foreign key → orders.id
- applied — boolean — NOT NULL
- ignored_reason — varchar(255)
- payload — jsonb
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
appraisal_statuses
- id — serial — Primary key — NOT NULL
- status — varchar(30) — NOT NULL
banners
- id — serial — Primary key — NOT NULL
- order — integer — NOT NULL
- image — varchar(50) — NOT NULL
- title — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
boards
- id — serial — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- views — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
brands
- id — serial — Primary key — NOT NULL
- category_id — integer — Foreign key → categories.id — NOT NULL
- name_kr — varchar(30) — NOT NULL
- name_en — varchar(30) — NOT NULL
- is_online — boolean — NOT NULL
- is_ai — boolean — NOT NULL
- is_popular — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
categories
- id — serial — Primary key — NOT NULL
- name_kr — varchar(30) — NOT NULL
- name_en — varchar(30) — NOT NULL
- image — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- is_online — boolean — NOT NULL
- is_ai — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
comments
- id — serial — Primary key — NOT NULL
- board_id — integer — Foreign key → boards.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
contact_answers
- id — serial — Primary key — NOT NULL
- contact_id — integer — Foreign key → contacts.id — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
contacts
- id — serial — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- title — varchar(50) — NOT NULL
- content — text — NOT NULL
- answer — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
faq
- id — serial — Primary key — NOT NULL
- title — varchar(50) — NOT NULL
- faq_type — varchar(50) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
google_chat_messages
- id — integer — Primary key — NOT NULL
- group_id — varchar(255)
- message_id — varchar(255) — NOT NULL
- bot_name — varchar(255)
- type — varchar(255) — NOT NULL
- type_id — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
notifications
- id — serial — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- title — varchar(50) — NOT NULL
- content — text — NOT NULL
- page — varchar(255)
- page_id — integer
- is_read — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
online_appraisals
- id — serial — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- status_id — integer — Foreign key → appraisal_statuses.id — NOT NULL
- brand_id — integer — Foreign key → brands.id — NOT NULL
- order_id — integer — Foreign key → orders.id
- prd_name — varchar(50)
- prd_num — varchar(50)
- purchase_loc — varchar(50)
- purchase_price — varchar(100)
- purchase_date — timestamp
- repair_history — varchar(50)
- appraisal_type — varchar(50)
- note — text
- ai_point — varchar(50)
- ai_status — integer
- serial — varchar(50)
- is_confirm — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
online_images
- id — serial — Primary key — NOT NULL
- appraisal_id — integer — Foreign key → online_appraisals.id — NOT NULL
- ontology_id — integer — NOT NULL
- images — jsonb — NOT NULL
- feedback — varchar(50)
- is_pass — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
ontologies
- id — integer — Primary key — NOT NULL
- brand_id — integer — Foreign key → brands.id — NOT NULL
- name_kr — varchar(30) — NOT NULL
- name_en — varchar(30) — NOT NULL
- content — varchar(255) — NOT NULL
- memo — varchar(255)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
orders
- id — serial — Primary key — NOT NULL
- status — varchar(30) — NOT NULL
- purchase_token — varchar(150)
- transaction_id — varchar(150)
- prd_id — varchar(150)
- platform — varchar(50)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- original_transaction_id — varchar(150)
payment_audit_logs
- id — serial — Primary key — NOT NULL
- order_id — integer — Foreign key → orders.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- appraisal_id — integer — Foreign key → online_appraisals.id
- event_type — varchar(50) — NOT NULL
- status_before — varchar(30)
- status_after — varchar(30) — NOT NULL
- platform — varchar(20) — NOT NULL
- transaction_id — varchar(150)
- purchase_token — varchar(150)
- product_id — varchar(150)
- amount — numeric(10, 2)
- currency — varchar(10) — NOT NULL
- validation_response — jsonb
- success — boolean — NOT NULL
- error_message — text
- error_code — varchar(50)
- created_at — timestamp with time zone — NOT NULL
- original_transaction_id — varchar(150)
qa_items
- item_pk — bigserial — Primary key — NOT NULL
- item_id — text — NOT NULL
- lang — text — NOT NULL
- scope — text — NOT NULL
- answer — text — NOT NULL
- is_button — boolean — NOT NULL
- action_data — jsonb
- extra_data — jsonb
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
qa_patterns
- pattern_pk — bigserial — Primary key — NOT NULL
- item_fk — bigint — Foreign key → qa_items.item_pk — NOT NULL
- pattern_text — text — NOT NULL
- embedding — vector(4096) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
users
- id — uuid — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(100) — NOT NULL
- reset_token — varchar
- reset_token_expires — timestamp
- fcm_token — varchar
- name — varchar(50)
- phone — varchar(15)
- provider — varchar(50)
- user_type — varchar(50)
- is_agree — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL