new_daily_insurances

Tables (7)

AutoInsurance (auto_insurance)

  • Key — INT(11) — Primary key — NOT NULL
  • Key (user_email) — VARCHAR(255)) — Foreign key → User.Key — NOT NULL
  • Key (insurance) — INT(11) — Foreign key → Insurance.Key — NOT NULL
  • Field (priority) — INTEGER
  • Field (create_time) — DATETIME

Insurance (insurances)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (sub_title) — VARCHAR(255)
  • Field (content) — TEXT()
  • Field (guaranteed_amount) — DECIMAL
  • Field (guarantee_period) — INTEGER
  • Field (main_image) — VARCHAR(255)
  • Field (create_time) — DATETIME
  • Field (update_time) — DATETIME
  • Field (create_user) — VARCHAR(255)
  • Field (update_user) — VARCHAR(255)

InsuranceClaimStatus (insurance_clame_status)

  • Key (ID) — INT(11) — Primary key — NOT NULL
  • Key (claim_insurance) — INT(11) — Foreign key → Insurance.Key — NOT NULL
  • Key (user_email) — VARCHAR(255) — Foreign key → User.Key — NOT NULL
  • Key (processing_status) — INT(11) — Foreign key → SwiftCode.Key — NOT NULL
  • Field (claim_date) — DATETIME
  • Field (create_time) — DATETIME
  • Field (content) — TEXT

InsuranceUser (insurances_users)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (user_email) — VARCHAR(255) — Foreign key → User.Key — NOT NULL
  • Key (insuarance) — INT(11) FK — Foreign key → Insurance.Key — NOT NULL
  • Key (product) — INT(11) — Foreign key → Product.Key — NOT NULL
  • Field (subscription_date) — DATETIME
  • Field (expiry_date) — DATETIME
  • Field (create_time) — DATETIME

Product (products)

  • Key (id) — INT(11) — Primary key — NOT NULL

SwiftCode (Untitled)

  • Key — Primary key — NOT NULL

User (users)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (auto_insurance) — BOOLEAN