Gpass

Tables (6)

Untitled (users)

  • Key (id) — bigint — Primary key — NOT NULL — auto-increament
  • Field (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp
  • Field (deletedAt) — timestamp
  • Field (email) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (user_name) — varchar(255) — NOT NULL
  • Field2 (phone_number) — varchar(255)
  • Field3 (is_verified) — int — NOT NULL
  • Field4 (ci) — varchar(255)
  • Field5 (role)
  • Field6 (profile)
  • Field7 (landmark)
  • Field8 (divice)
  • Field (corp)
  • Field2 (branch)
  • Field3 (commute)

Untitled (user_profiles)

  • Key (id) — bigint — Primary key — NOT NULL — auto-increament
  • Field (nickname) — varchar(255)
  • Field (birth)
  • Field (is_foreigner)
  • Field2 (phone_provider)
  • Field3 (saves_landmarks)
  • Field4 (card_id)
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto-increament

Untitled (user_landmarks)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (landmark)
  • Field2 (is_saved_on_server)
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto-increament

Untitled (user_devices)

  • Key (id) — bigint — Primary key — NOT NULL — auto_increament
  • Field (device_name) — varchar(60) — NOT NULL
  • Field (os_version)
  • Field (device_type)
  • Field (app_version)
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto-increament

Untitled (branch_users)

  • Key (id) — bigint — Primary key — NOT NULL — auto-increament
  • Field (job_title) — varchar(60)
  • Field (role) — varchar(60)
  • Field (invitattion_status) — varchar(60) — NOT NULL
  • Key (corp_id) — bigint — Foreign key → user.Key — NOT NULL — auto-increament
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto-increament

user (corps)

  • Key (id) — bigint — Primary key — NOT NULL — auto-increament
  • Field (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp
  • Field2 (deletedAt) — timestamp
  • Field3 (login_id) — varchar(255) — NOT NULL
  • Field4 (password) — varchar(255) — NOT NULL
  • Field5 (corp_name) — varchar(255) — NOT NULL