needsclear

Tables (23)

TBL_ADMIN

  • idx (Key) — int — Primary key — NOT NULL
  • admin_id (Field) — text
  • admin_pass (Field2) — text
  • admin_type (Field3) — int

TBL_CHAUFFEUR

  • idx (Key) — int — Primary key — NOT NULL
  • create_at (Field) — datetime
  • start_address (Field2) — text
  • end_address (Field3) — text
  • id (Field4) — text
  • name (Field5) — text
  • phone (Field6) — text
  • payment (Field7) — int
  • gisa_name (Field8) — text
  • gisa_phone (Field9) — text
  • type (Field10) — int

TBL_COLLECTION_AREA

  • idx (Key) — int — Primary key — NOT NULL
  • area (Field) — text

TBL_DEVICE

  • idx (Key) — int — Primary key — NOT NULL
  • device_image (Field) — mediumblob
  • device_name (Field2) — text
  • device_description (Field3) — text

TBL_DRESS

  • idx (Key) — int — Primary key — NOT NULL
  • dr_name (Field) — text
  • dr_type (Field2) — int
  • dr_payment (Field3) — int

TBL_EVENT

  • idx (Key) — int — Primary key — NOT NULL
  • create_at (Field) — datetime
  • title (Field2) — text
  • image (Field3) — mediumblob

TBL_FAQ

  • idx (Key) — int — Primary key — NOT NULL
  • question (Field) — text
  • answer (Field2) — text
  • create_at (Field3) — datetime

TBL_INQUIRY

  • idx (Key) — int — Primary key — NOT NULL
  • id (Field) — text
  • title (Field2) — text
  • question (Field3) — text
  • answer (Field4) — text
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

TBL_INTERNET

  • idx (Key) — int — Primary key — NOT NULL
  • id (Field) — text
  • name (Field2) — text
  • phone (Field3) — text
  • apply_newsagency (Field4) — text
  • apply_service (Field5) — text
  • type (Field6) — int
  • payment (Field7) — int
  • created_at (Field8) — timestamp

TBL_INTERNET_NEWSAGENCY

  • idx (Key) — int — Primary key — NOT NULL
  • newsagency (Field) — text

TBL_INTERNET_SERVICE

  • idx (Key) — int — Primary key — NOT NULL
  • item (Field) — text

TBL_LAUNDRY

  • idx (Key) — text — Primary key — NOT NULL
  • code (Field) — text
  • la_name (Field2) — text
  • la_payment (Field3) — int
  • la_type (Field4) — int
  • la_count (Field5) — int

TBL_NOTICE

  • idx (Key) — int — Primary key — NOT NULL
  • title (Field) — text
  • content (Field2) — text
  • created_at (Field3) — datetime

TBL_PHONE

  • idx (Key) — int — Primary key — NOT NULL
  • id (Field) — text
  • name (Field2) — text
  • phone (Field3) — text
  • now_newsagency (Field4) — text
  • change_newsagency (Field5) — text
  • service_type (Field6) — int
  • type (Field7) — int
  • payment (Field8) — int
  • device_name (Field9) — text
  • created_at (Field10) — datetime

TBL_POINT

  • idx (Key) — int — Primary key — NOT NULL
  • type (Field) — int
  • service_type (Field2) — int
  • reword_type (Field3) — int
  • myself_percent (Field4) — int
  • directly_percent (Field5) — int
  • indirect_percent (Field6) — int
  • myself_point (Field7) — int
  • directly_point (Field8) — int
  • indirect_point (Field9) — int

TBL_PREMIUM

  • idx (Key) — int — Primary key — NOT NULL
  • updated_at (Field) — datetime
  • content (Field2) — text

TBL_QUICK

  • idx (Key) — int — Primary key — NOT NULL
  • id (Field) — text
  • name (Field2) — text
  • phone (Field3) — text
  • start_address (Field4) — int
  • end_address (Field5) — int
  • vehicle (Field6) — text
  • article (Field7) — text
  • damage (Field8) — text
  • type (Field9) — int
  • price (Field10) — int

TBL_QUICK_OPTION

  • idx (Key) — int — Primary key — NOT NULL
  • type (Field) — int
  • value (Field2) — text

TBL_RECO

  • idx (Key) — int — Primary key — NOT NULL
  • user_idx (Field) — int
  • id (Field2) — varchar
  • reco_code (Field3) — varchar

TBL_RECO_REGISTER

  • idx (Key) — int — Primary key — NOT NULL
  • reco_idx (Field) — int
  • reco_code (Field2) — text
  • name (Field3) — text
  • phone (Field4) — text

TBL_SAVE_LOG

  • idx (Key) — int — Primary key — NOT NULL
  • date (Field) — datetime
  • id (Field2) — varchar
  • name (Field3) — varchar
  • phone (Field4) — varchar
  • point (Field5) — int
  • save_month (Field6) — varchar
  • save_place (Field7) — int
  • save_type (Field8) — int
  • type (Field9) — int

TBL_USERS

  • idx (Key) — int — Primary key — NOT NULL
  • id (Field) — varchar
  • name (Field2) — varchar
  • phone (Field3) — varchar
  • birth_day (Field4) — varchar
  • type (Field5) — int
  • point (Field6) — int
  • push_reco_code (Field7) — varchar
  • reco_code (Field8) — varchar
  • reco_person (Field9) — int
  • reco_price (Field10) — int
  • gender (Field11) — int
  • sign_date (Field12) — varchar
  • dl_point (Field13) — decimal
  • auto_sale (Field14) — int

TBL_WASH

  • idx (Key) — int — Primary key — NOT NULL
  • collection_type (Field) — int
  • wash_type (Field2) — int
  • address (Field3) — text
  • wash_payment (Field4) — int
  • id (Field5) — text
  • phone (Field6) — text
  • name (Field7) — text
  • code (Field8) — text
  • created_at (Field9) — datetime