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