dasigo

Tables (21)

Chat (Untitled19)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • quote (Key2) — ForeignKey — Foreign key → Quote.id — NOT NULL
  • user (Key4) — ForeignKey — Foreign key → User.id — NOT NULL
  • repair_shop (Key3) — ForeignKey — Foreign key → RepairShop.id — NOT NULL
  • message_last_updated (Field) — DateTimeField

Estimate (Untitled8)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • user (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • product (Key3) — ForeignKey — Foreign key → Product.id — NOT NULL
  • type (Field) — ForeignKey
  • item (Field2) — ForeignKey
  • brand (Field3) — ForeignKey
  • name (Field4) — CharField
  • damaged_area_set (Field5) — ManyToManyField
  • description (Field6) — TextField
  • address (Field7) — CharField
  • address_detail (Field8) — CharField
  • latitude (Field9) — FloatField
  • longitude (Field10) — FloatField
  • status (Field11) — CharField
  • consult_start_date (Field12) — DateField
  • repair_start_date (Field13) — DateField
  • repair_done_date (Field14) — DateField
  • paid_date (Field15) — DateField
  • is_vbank (Field16) — BooleanField

EstimateImage (Untitled9)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • estimate (Key2) — ForeignKey — Foreign key → Estimate.id — NOT NULL
  • image (Field) — ImageField

EstimateWatch (Untitled21)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • chat (Key2) — OneToOneField — Foreign key → Chat.id — NOT NULL
  • is_estimate_paid (Field) — BooleanField
  • Field2

Event (Untitled7)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • name (Field) — CharField
  • image (Field2) — ImageField
  • url (Field3) — URLField
  • button (Field4) — CharField
  • exposure_start (Field5) — DateField
  • exposure_end (Field6) — DateField

EventRegister (Untitled6)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • event (Key2) — ForeignKey — Foreign key → Event.id — NOT NULL
  • user (Key3) — ForeignKey — Foreign key → User.id — NOT NULL

Message (Untitled20)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • chat (Key2) — ForeignKey — Foreign key → Chat.id — NOT NULL
  • user (Key3) — ForeignKey — Foreign key → User.id — NOT NULL
  • type (Field) — CharField
  • text (Field2) — TextField
  • image (Field3) — URLField

Payment (Untitled17)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • estimate (Key2) — ForeignKey — Foreign key → Estimate.id — NOT NULL
  • location (Field) — CharField
  • merchant_uid (Field2) — CharField
  • imp_uid (Field3) — CharField
  • pay_method (Field4) — CharField
  • amount (Field5) — IntegerField
  • channel (Field6) — CharField
  • pg_provider (Field7) — CharField
  • emb_pg_provider (Field8) — CharField
  • pg_tid (Field9) — CharField
  • escrow (Field10) — BooleanField
  • apply_num (Field11) — CharField
  • bank_code (Field12) — CharField
  • bank_name (Field13) — CharField
  • card_code (Field14) — CharField
  • card_name (Field15) — CharField
  • card_quota (Field16) — IntegerField
  • card_number (Field17) — CharField
  • card_type (Field18) — IntegerField
  • vbank_code (Field19) — CharField
  • vbank_name (Field20) — CharField
  • vbank_holder (Field21) — CharField
  • vbank_date (Field22) — IntegerField
  • vbank_issued_at (Field23) — IntegerField
  • status (Field24) — CharField
  • name (Field25) — CharField
  • cancel_amount (Field26) — IntegerField
  • currency (Field27) — CharField
  • buyer_name (Field28) — CharField
  • buyer_email (Field29) — CharField
  • buyer_tel (Field30) — CharField
  • buyer_addr (Field31) — CharField
  • buyer_postcode (Field32) — CharField
  • custom_data (Field33) — CharField
  • user_agent (Field34) — CharField
  • started_at (Field35) — IntegerField
  • paid_at (Field36) — IntegerFIeld
  • failed_at (Field37) — IntegerField
  • fail_reason (Field38) — CharField
  • cancelled_at (Field39) — IntergerField
  • cancel_reason (Field40) — CharField
  • receipt_url (Field41) — CharField
  • cancel_history (Field42) — TextField
  • cancel_receipt_urls (Field43) — TextField
  • cash_receipt_issued (Field44) — BooleanField

Product (내 제품)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • user (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • type (Field) — ForeignKey
  • item (Field2) — ForeignKey
  • brand (Field3) — ForeignKey
  • name (Field4) — CharField
  • serial_number (Field5) — CharField
  • model (Field6) — CharField
  • purchase_date (Field7) — DateField
  • warranty_duration (Field8) — CharField

ProductReceipt (Untitled4)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • product (Key2) — ForeignKey — Foreign key → Product.id — NOT NULL
  • image (Field) — ImageField

Quote (Untitled10)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • estimate (Key2) — ForeignKey — Foreign key → Estimate.id — NOT NULL
  • repair_shop (Key3) — ForeignKey — Foreign key → RepairShop.id — NOT NULL
  • expectation_amount (Field) — IntegerField
  • middle_amount (Field2) — IntegerField
  • total_amount (Field3) — IntegerField
  • is_expectation_send (Field4) — BooleanField
  • is_middle_send (Field5) — BooleanField
  • is_middle_confirm (Field6) — BooleanField
  • is_repair_done (Field7) — BooleanField
  • middle_damaged_area_set (Field8) — ManyToManyField
  • middle_description (Field9) — TextField
  • total_damaged_area_set (Field10) — ManyToManyField
  • total_description (Field11) — TextField

RepairShop (Untitled11)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • user (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • name (Field) — CharField
  • address (Field2) — CharField
  • address_detail (Field3) — CharField
  • latitude (Field4) — FloatField
  • longitude (Field5) — FloatField
  • phone (Field6) — CharField
  • item_set (Field7) — ManyToManyField
  • smartphone_os (Field8) — CharField
  • description (Field9) — TextField
  • profile (Field10) — ImageField
  • greetings (Field11) — TextField
  • is_app_approach (Field12) — BooleanField
  • is_direct_search (Field13) — BooleanField
  • is_advertise (Field14) — BooleanField
  • is_friend (Field15) — BooleanField
  • is_etc (Field16) — BooleanField
  • etc_direct_input (Field17) — CharField
  • is_benefit_alarm_agree (Field18) — BooleanField
  • is_estimation_alarm (Field19) — BooleanField
  • is_chatting_alarm (Field20) — BooleanField
  • is_custom_benefit_agree (Field21) — BooleanField
  • business_registration_number (Field22) — CharField
  • texation (Field23) — CharField
  • business_type (Field24) — CharField
  • type (Field25) — CharField
  • business_name (Field26) — CharField
  • representative_kind (Field27) — CharField
  • representative_birth (Field28) — CharField
  • business_address (Field29) — CharField
  • business_address_detail (Field30) — CharField
  • business_registration (Field31) — FileField
  • account_holder (Field32) — CharField
  • account_birth (Field33) — CharField
  • bank (Field34) — ForeignKey
  • account_number (Field35) — CharField
  • bankbook (Field36) — ImageField
  • register_status (Field37) — CharField
  • is_repair_withdrawal (Field38) — BooleanField
  • commision (Field39) — FloatField

RepairShopPrice (Untitled12)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • repair_shop (Key2) — ForeignKey — Foreign key → RepairShop.id — NOT NULL
  • image (Field) — ImageField

Reply (Untitled15)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • review (Key2) — ForeignKey — Foreign key → Review.id — NOT NULL
  • content (Field) — TextField

Review (Untitled13)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • repair_shop (Key2) — ForeignKey — Foreign key → RepairShop.id — NOT NULL
  • estimate (Key3) — ForeignKey — Foreign key → Estimate.id — NOT NULL
  • repair_satisfaction (Field) — IntegerField
  • kindness (Field2) — IntegerField
  • estimate_accuracy (Field3) — IntegerField
  • content (Field4) — TextField

ReviewImage (Untitled14)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • review (Key2) — ForeignKey — Foreign key → Review.id — NOT NULL
  • image (Field) — ImageField

ReviewReport (Untitled16)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • review (Key2) — ForeignKey — Foreign key → Review.id — NOT NULL
  • is_fake (Field) — BooleanField
  • is_no_relation (Field2) — BooleanField
  • is_discomfort (Field3) — BooleanField

Settlement (Untitled18)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • payment (Key2) — ForeignKey — Foreign key → Payment.id — NOT NULL
  • repair_shop (Key3) — ForeignKey — Foreign key → RepairShop.id — NOT NULL
  • amount (Field) — IntegerField
  • paid_at (Field2) — DateTimeField
  • settlement_amount (Field3) — IntegerField
  • settlement_date (Field4) — DateTiemField
  • is_settled (Field5) — BooleanField

User (유저)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • username (Field) — CharField
  • email (Field2) — EmailField
  • profile (Field3) — ImageField
  • is_custom_benefit_agree (Field4) — BooleanField
  • is_benefit_alarm_agree (Field5) — BooleanField
  • is_estimation_alarm (Field6) — BooleanField
  • is_chatting_alarm (Field7) — BooleanField
  • is_repair_shop (Field8) — BooleanField
  • is_repair_active (Field9) — BooleanField
  • is_withdrawal (Field10) — BooleanField

UserAddress (Untitled2)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • user (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • name (Field) — CharField
  • address (Field2) — CharField
  • address_detail (Field3) — CharField
  • latitude (Field4) — FloatField
  • longitude (Field5) — FloatField
  • is_default (Field6) — BooleanField

device (Untitled5)

  • id (Key) — IntegerField — Primary key — NOT NULL
  • user (Key2) — ForeignKey — Foreign key → User.id — NOT NULL
  • uid (Field) — CharField
  • token (Field2) — CharField