mission1

Tables (5)

Mission (Untitled3)

  • mission_id (Key2) — BIGINT — Primary key — NOT NULL
  • Store_id (Key) — BIGINT — Foreign key → store.Store_id — NOT NULL
  • Regoin_id (Key22) — BIGINT — Foreign key → store.Regoin_id — NOT NULL
  • name (Field2) — VARCHAR(20)
  • Description (Field) — VARCHAR(20)

Region (Untitled5)

  • Regoin_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(20)

mission_history (Untitled2)

  • Record_id (Key) — BIGINT — Primary key — NOT NULL
  • id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
  • mission_id (Key22) — BIGINT — Foreign key → Mission.mission_id — NOT NULL
  • mission_detail (Field) — TEXT

store (Untitled4)

  • Store_id (Key) — BIGINT — Primary key — NOT NULL
  • Regoin_id (Key2) — BIGINT — Foreign key → Region.Regoin_id — NOT NULL
  • name (Field) — VARCHAR(20)

user (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(20)
  • create_at (Field2) — DATETIME
  • update_at (Field3) — DATETIME
  • status (Field4) — VARCHAR(20)
  • address (Field5) — TEXT
  • inactive_data (Field6) — DATETIME
  • user_id (Field7) — VARCHAR(20)
  • password (Field8) — VARCHAR(20)