ubhelper

Tables (14)

Bank account table (t_bank_account)

  • Account Id (id) — int(11) — Primary key — NOT NULL
  • Bank account number (account_number) — varchar(20)
  • Is account active? (is_active) — boolean
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL
  • Bank id (bank_id) — int(11) — Foreign key → Banks.Bank id — NOT NULL

Banks (t_banks)

  • Bank id (id) — int(11) — Primary key — NOT NULL
  • Bank name (bank_name) — varchar(30)
  • Local fees (local_fees) — double
  • Other bank fees (other_fees) — double

Favorite (t_users_favorite)

  • ID (id) — int(11) — Primary key — NOT NULL
  • Gave the rating (gave_user) — int(11) — Foreign key → user table.User ID — NOT NULL
  • Rated user (rated_user) — int(11) — Foreign key → user table.User ID — NOT NULL

Gender (t_gender)

  • Gender ID (id) — int(11) — Primary key — NOT NULL
  • Gender (gender) — varchar(20)

Job List (t_job)

  • Job id (id) — int(11) — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Salary (salary) — double
  • Working time (work_time) — int
  • Created date (created_at) — timestamp
  • Start date (start_at) — timestamp
  • End date (end_at) — timestamp
  • Description (description) — varchar(255)
  • Job status (status) — int(11) — Тухайн зарласан ажлын төлөв. Жишээлбэл: 1. Зарлагдсан 2. Ажилтан хүлээж авсан 3. Хийгдэж байгаа 4. Дууссан гэх мэт
  • Location Latitude (latitude) — Decimal(8,6)
  • Location Longitude (longitude) — Decimal(9,6)
  • Canceled? (is_canceled) — boolean
  • Canceled memo (memo) — varchar(100)
  • Category id (category_id) — int(11) — Foreign key → Job category.Category id — NOT NULL
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL

Job apply requests (t_job_apply)

  • Apply ID (id) — int(11) — Primary key — NOT NULL
  • Send request date (created_at) — timestamp
  • Apply status (apply_status) — int(11)
  • Cancelled memo (memo) — varchar(100)
  • Worker id (worker_id) — int(11) — Foreign key → user table.User ID — NOT NULL
  • Job id (id2) — int(11) — Foreign key → Job List.Job id — NOT NULL

Job category (t_job_category)

  • Category id (id) — int(11) — Primary key — NOT NULL
  • Category name (category_name) — varchar(50)

Transaction history (t_transaction)

  • Transaction id (id) — int(11) — Primary key — NOT NULL
  • Sender bank (sender)
  • Sender account number (sender_account_number) — varchar(20)
  • Receiver Bank (receiver)
  • Receiver account number (receiver_account_number) — varchar(20)
  • Transaction amount (amount) — double
  • Transaction fees (trans_fees) — double
  • Transaction status (status) — varchar(10) — Энэ хэсэгт дундын дансруу мөнгө орж ирсэн үү? Эсвэл гарсан уу? гэдэг төлвөө хадгалах.
  • Transaction types (trans_type) — varchar(20) — Энэ нь хэтэвч цэнэглэлт үү, Ажлын хөлс үү гэдгээ ялгах хэсэг
  • Created date (created_at) — timestamp
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL

User review table (t_users_review)

  • Review Id (id) — int(11) — Primary key — NOT NULL
  • Review name (stamp_name) — varchar(50) — NOT NULL — Энэ дээр хэдэн статик тамгануудаас сонгуулаад тавья гэж бодож байна. Сайн ажилтан, Шилдэг ажилтан юу юу ч гэдэг юм тийм…
  • Review point (point) — int(11)
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL

User roles (t_roles)

  • Role id (id) — int(11) — Primary key — NOT NULL
  • Role name (role) — varchar(50)

User verified? (t_users_verified)

  • ID (id) — int(11) — Primary key — NOT NULL
  • ID card front (id_card_front) — varchar(255)
  • ID card back (id_card_back) — varchar(255)
  • ID card with selfie (id_card_selfie) — varchar(255)
  • Is verified? (is_verified) — boolean

Wallet table (t_users_wallet)

  • Wallet id (id) — int(11) — Primary key — NOT NULL
  • Balance (balance) — double
  • Updated date (updated_at) — timestamp
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL

user table (t_users)

  • User ID (id) — int(11) — Primary key — NOT NULL
  • First name (first_name) — varchar(30)
  • Last Name (last_name) — varchar(30)
  • Phone number (phone) — varchar(12)
  • Phone verified (phone_verified) — boolean
  • Email (email) — varchar(100)
  • Email verified (emial_verified) — boolean
  • Register number (register) — varchar(10)
  • Profile image (profile) — varchar(255)
  • Home address (address) — varchar(255)
  • User password (password) — varchar(255)
  • User verified (is_verified) — int(11) — Foreign key → User verified?.ID — NOT NULL
  • User role (role_id) — int(11) — Foreign key → User roles.Role id — NOT NULL
  • Gender ID (gender) — int(11) — Foreign key → Gender.Gender ID — NOT NULL
  • Created date (created_at) — timestamp

user-generated-token (t_user_token)

  • Token ID (id) — int(11) — Primary key — NOT NULL
  • Created date (created_at) — timestamp
  • Generated token (token) — text
  • Is active? (is_active) — boolean
  • User ID (user_id) — int(11) — Foreign key → user table.User ID — NOT NULL