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