경매톡_v2

테이블 (26)

auction_schedule

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • date — date
  • price — bigint
  • result — varchar(255)
  • round — int — NOT NULL

counsel

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • counsel_date — date
  • counsel_status — enum
  • counsel_time — time(6)
  • push_sent — bit — NOT NULL
  • counsel_form_id — bigint
  • counselor_id — bigint
  • member_id — bigint

counsel_form

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • area — varchar(255)
  • interest — varchar(255)
  • participant_type — varchar(255)
  • purpose — varchar(255)
  • service_type — varchar(255)
  • member_id — bigint

counselor

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • specialization — varchar(255)
  • cell_phone — varchar(255)
  • counsel_count — int — NOT NULL
  • description — varchar(255)
  • experience — int
  • license — varchar(255)
  • name — varchar(255)

counselor_image

  • id — bigint
  • url — varchar(255) — NOT NULL
  • counselor_id — bigint

faq

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • answer — varchar(250) — NOT NULL
  • question — varchar(255) — NOT NULL

member

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • birth — date
  • cell_phone — varchar(255)
  • client_id — varchar(255) — NOT NULL
  • fcm_token — varchar(255)
  • login_type — enum
  • name — varchar(255)
  • property_notification_enabled — bit — NOT NULL
  • review_notification_enabled — bit — NOT NULL
  • password — varchar(255)
  • registered — bit — NOT NULL
  • role — enum
  • username — varchar(255)
  • revenue_cat_app_user_id — varchar(255)

member_view_ticket_wallet

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • balance — int — NOT NULL
  • member_id — bigint — NOT NULL

notification

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • body — varchar(255)
  • content_id — bigint
  • counsel_time — datetime(6)
  • counselor_name — varchar(255)
  • is_read — bit — NOT NULL
  • property_name — varchar(255)
  • thumbnail — varchar(255)
  • title — varchar(255)
  • type — enum
  • member_id — bigint — NOT NULL

orders

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • amount — bigint
  • counselor_id — bigint
  • idempotency_key — varchar(255)
  • order_number — varchar(255)
  • order_status — enum
  • product_code — varchar(255)
  • product_name — varchar(255)
  • product_type — enum
  • member_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL

payments

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • acknowledged_at — datetime(6)
  • approved_amount — bigint
  • approved_at — datetime(6)
  • failed_at — datetime(6)
  • failure_code — varchar(255)
  • failure_reason — varchar(255)
  • payment_number — varchar(255)
  • payment_provider — enum
  • payment_status — enum
  • provider_transaction_id — varchar(255)
  • requested_amount — bigint
  • sandbox — bit
  • store — varchar(255)
  • store_product_id — varchar(255)
  • order_id — bigint — NOT NULL

product

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • active — bit — NOT NULL
  • description — varchar(255)
  • name — varchar(255)
  • original_price — bigint
  • price — bigint
  • product_type — enum
  • recommended — bit — NOT NULL
  • store_product_id — varchar(255)

product_component

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • component_type — enum
  • description — varchar(500)
  • name — varchar(100) — NOT NULL

product_component_mapping

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • quantity — int
  • product_component_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL

property

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(255)
  • appraised_price — bigint
  • area — int
  • building_type — varchar(255)
  • case_number — varchar(255)
  • case_title — varchar(255)
  • commencement_date — date
  • court_name — varchar(255)
  • creditor — varchar(255)
  • debtor — varchar(255)
  • expert_comment — varchar(255) — archar(255) nul
  • is_purchased — bit — NOT NULL
  • min_price — bigint
  • name — varchar(255)
  • owner — varchar(255)
  • registration_date — date
  • status — varchar(255)
  • tenant — varchar(255)
  • counselor_id — bigint
  • member_id — bigint
  • is_payment — bit — NOT NULL

property_auction_schedules

  • property_id — bigint — NOT NULL
  • auction_schedules_id — bigint — NOT NULL

property_image

  • id — bigint
  • url — varchar(255) — NOT NULL
  • property_id — bigint

property_payment

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • status — enum
  • member_id — bigint
  • property_id — bigint

qna

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • category — enum — NOT NULL
  • content — varchar(250) — NOT NULL
  • status — enum — NOT NULL
  • title — varchar(255) — NOT NULL
  • member_id — bigint — NOT NULL

qna_answer

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(250) — NOT NULL
  • qna_id — bigint — NOT NULL

review

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • score — int — NOT NULL
  • counsel_id — bigint
  • member_id — bigint

review_image

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • url — varchar(255) — NOT NULL
  • review_id — bigint

review_report

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • report_type — tinyint
  • member_id — bigint
  • review_id — bigint

subscription

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • end_date — datetime(6)
  • start_date — datetime(6)
  • subscription_status — enum — NOT NULL
  • counselor_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

subscriptions

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • end_date — datetime(6)
  • source_order_id — bigint
  • start_date — datetime(6)
  • subscription_status — enum — NOT NULL
  • counselor_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • payment_id — bigint — NOT NULL

view_ticket_grant_histories

  • id — bigint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • updated_at — datetime(6)
  • quantity — int — NOT NULL
  • order_id — bigint — NOT NULL
  • product_component_id — bigint — NOT NULL