service

Tables (5)

discount

  • discount_id — bigint — Primary key — NOT NULL
  • discount_price — integer
  • name — varchar(255)
  • type — varchar(255)

insurance

  • insurance_id — bigint — Primary key — NOT NULL
  • insurance_price — integer — NOT NULL
  • max_price — integer — NOT NULL
  • min_price — integer — NOT NULL
  • name — varchar(255)
  • ostype — varchar(255)

phone_discount

  • phonediscount_id — bigint — Primary key — NOT NULL
  • discount_id — bigint
  • phone_id — bigint

plan

  • plan_id — bigint — Primary key — NOT NULL
  • data_usage — integer
  • generation — integer
  • name — varchar(255)
  • price — integer

product

  • phone_id — bigint — Primary key — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • created_at — date
  • forward_price — integer
  • name — varchar(255)
  • color — varchar(255)
  • generation — varchar(255)
  • image_path — varchar(255)
  • maker — varchar(255)
  • ostype — varchar(255)
  • public_support_price — integer
  • storage — integer