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