quazar-app-renewal
Tables (19)
appraisal_images
- id — BIGSERIAL — Primary key — NOT NULL
- online_appraisal_id — BIGINT — Foreign key → online_appraisals.id — NOT NULL
- inspection_part_id — BIGINT — Foreign key → inspection_parts.id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- storage_key — VARCHAR(255)
- original_filename — VARCHAR(255)
- content_type — VARCHAR(100)
- file_size — BIGINT
- sort_order — INTEGER
- is_primary — BOOLEAN — NOT NULL
- ai_feedback — TEXT
- ai_passed — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
appraisal_status_codes
- id — BIGSERIAL — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- label_ko — VARCHAR(50) — NOT NULL
- sort_order — INTEGER
- active — BOOLEAN — NOT NULL
banners
- id — BIGSERIAL — Primary key — NOT NULL
- display_order — INTEGER — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- target_url — VARCHAR(255)
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
board_comments
- id — BIGSERIAL — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → board_posts.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
- deleted_at — TIMESTAMP
board_posts
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
brand_categories
- id — BIGSERIAL — Primary key — NOT NULL
- brand_id — BIGINT — Foreign key → brands.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
- active — BOOLEAN — NOT NULL
- online_enabled — BOOLEAN — NOT NULL
- ai_enabled — BOOLEAN — NOT NULL
- popular_exposed — BOOLEAN — NOT NULL
- sort_order — INTEGER
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
brands
- id — BIGSERIAL — Primary key — NOT NULL
- name_ko — VARCHAR(100) — NOT NULL
- name_en — VARCHAR(100) — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
categories
- id — BIGSERIAL — Primary key — NOT NULL
- name_ko — VARCHAR(50) — NOT NULL
- name_en — VARCHAR(50) — NOT NULL
- image_url — VARCHAR(255)
- description — TEXT
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
contact_messages
- id — BIGSERIAL — Primary key — NOT NULL
- contact_id — BIGINT — Foreign key → contacts.id — NOT NULL
- writer_user_id — UUID — Foreign key → users.id
- writer_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
contacts
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- category — VARCHAR(30)
- status — VARCHAR(30) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- closed_at — TIMESTAMP
faqs
- id — BIGSERIAL — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- sort_order — INTEGER
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
inspection_parts
- id — BIGSERIAL — Primary key — NOT NULL
- brand_category_id — BIGINT — Foreign key → brand_categories.id — NOT NULL
- name_ko — VARCHAR(100) — NOT NULL
- name_en — VARCHAR(100) — NOT NULL
- guide_text — TEXT
- memo — TEXT
- sort_order — INTEGER
- required — BOOLEAN — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
notification_delivery_logs
- id — BIGSERIAL — Primary key — NOT NULL
- notification_id — BIGINT — Foreign key → notifications.id
- channel — VARCHAR(30) — NOT NULL
- target_type — VARCHAR(50) — NOT NULL
- target_id — BIGINT — NOT NULL
- external_message_id — VARCHAR(255)
- delivery_status — VARCHAR(30) — NOT NULL
- payload — JSONB
- created_at — TIMESTAMP — NOT NULL
notifications
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- body — TEXT — NOT NULL
- target_type — VARCHAR(50)
- target_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- read_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
online_appraisals
- id — BIGSERIAL — Primary key — NOT NULL
- appraisal_no — VARCHAR(50) — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- brand_category_id — BIGINT — Foreign key → brand_categories.id — NOT NULL
- status_code_id — BIGINT — Foreign key → appraisal_status_codes.id — NOT NULL
- appraisal_type — VARCHAR(30) — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- product_code — VARCHAR(100)
- purchase_location — VARCHAR(255)
- purchase_price — NUMERIC(12, 2)
- purchase_date — DATE
- repair_history — TEXT
- note — TEXT
- ai_score — NUMERIC(5, 2)
- ai_status — VARCHAR(30)
- final_result — VARCHAR(30)
- is_confirmed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
payment_audit_logs
- id — BIGSERIAL — Primary key — NOT NULL
- payment_order_id — BIGINT — Foreign key → payment_orders.id — NOT NULL
- payment_transaction_id — BIGINT — Foreign key → payment_transactions.id
- user_id — UUID — Foreign key → users.id — NOT NULL
- online_appraisal_id — BIGINT — Foreign key → online_appraisals.id
- event_type — VARCHAR(50) — NOT NULL
- status_before — VARCHAR(30)
- status_after — VARCHAR(30)
- success — BOOLEAN — NOT NULL
- error_code — VARCHAR(50)
- error_message — TEXT
- payload — JSONB
- created_at — TIMESTAMP — NOT NULL
payment_orders
- id — BIGSERIAL — Primary key — NOT NULL
- order_no — VARCHAR(50) — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- online_appraisal_id — BIGINT — Foreign key → online_appraisals.id
- brand_category_id — BIGINT — Foreign key → brand_categories.id — NOT NULL
- platform — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- amount — NUMERIC(12, 2) — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
payment_transactions
- id — BIGSERIAL — Primary key — NOT NULL
- payment_order_id — BIGINT — Foreign key → payment_orders.id — NOT NULL
- provider — VARCHAR(30) — NOT NULL
- transaction_id — VARCHAR(150)
- original_transaction_id — VARCHAR(150)
- purchase_token — VARCHAR(255)
- status — VARCHAR(30) — NOT NULL
- validated_at — TIMESTAMP
- raw_payload — JSONB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- id — UUID — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- phone — VARCHAR(30)
- provider — VARCHAR(30)
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- is_agree — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL