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