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