GBK

Tables (7)

accommodation

  • plan_id (Field13) — BIGINT
  • id (Field12) — BIGINT
  • name (Field5) — VARCHAR(50)
  • explain (Field) — TEXT
  • link (Field6) — TEXT
  • chack_in (Field11) — DATETIME
  • check_out (Field2) — DATETIME
  • address (Field3) — VARCHAR(50)

alert

  • id (Field3) — BIGINT
  • created_at (Field5) — DATETIME
  • title (Field) — VARCHAR(50)
  • context (Field2) — TEXT

chat

  • user_id (Field) — BIGINT
  • usr_chat_id (Field2) — BIGINT
  • plan_chat_id (Field7) — BIGINT
  • id (Field3) — BIGINT
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • content (Field8) — TEXT

plan

  • user_id (Field13) — BIGINT
  • id (Field12) — BIGINT
  • status (Field15) — TINYINT
  • title (Field5) — VARCHAR(50)
  • explain (Field) — TEXT
  • image (Field6) — TEXT
  • status (Field7) — TINYINT
  • access_at (Field9) — DATETIME
  • created_at (Field10) — DATETIME
  • updated_at (Field11) — DATETIME
  • period (Field14)
  • Field2

tos

  • id (Field3) — BIGINT
  • agree (Field4) — TINYINT
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • title (Field) — VARCHAR(50)
  • context (Field2) — TEXT

user

  • id (Field12) — BIGINT — Primary key
  • email (Field) — VARCHAR(50)
  • paassword (Field2) — TEXT
  • name (Field5) — VARCHAR(50)
  • nickname (Field3) — VARCHAR(50)
  • phone_number (Field4) — VARCHAR(50)
  • profile (Field6) — TEXT
  • status (Field7) — TINYINT
  • resign_at (Field8) — DATETIME
  • access_at (Field9) — DATETIME
  • created_at (Field10) — DATETIME
  • updated_at (Field11) — DATETIME

user_tos

  • user_id (Field) — BIGINT
  • usr_tos_id (Field2) — BIGINT
  • id (Field3) — BIGINT
  • agree (Field4) — TINYINT
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME