mTask
Tables (21)
agencys
- agency_key — varchar(45) — Primary key — NOT NULL
- agency_name — varchar(45)
- biz_reg_cert_url — varchar(45)
- business_reg — varchar(45)
- zip_code — varchar(45)
- address — varchar(45)
- ceo_first_name — varchar(45)
- ceo_last_name — varchar(45)
- phone_number — varchar(45)
- biz_scope — varchar(45)
- verified_yn — varchar(45)
- reg_date — datetime
agencys_user
- agency_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45)
- active_yn — varchar(2)
- reg_date — varchar(45)
blacklist
- user_key — varchar(45) — Primary key — NOT NULL
- device_id — varchar(45) — Primary key — NOT NULL
- ip — varchar(45) — Primary key — NOT NULL
- from_date — varchar(45)
- to_date — varchar(45)
- reason — varchar(45)
card_payments
- transction_id — varchar(45) — Primary key — NOT NULL
- contract_key — varchar(45)
- payment_remark — varchar(45) — Bonus, extra
- user_key — varchar(45)
- amount — double
- status — varchar(45)
- reg_date — datetime
- processing_fees — double
- service_fees_perc — double
- service_fees_amount — double
- ben_key — varchar(45)
- release_status — varchar(45)
- release_date — datetime
contracts
- contract_key — varchar(45) — Primary key — NOT NULL
- job_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45) — Primary key — NOT NULL
- price — double
- due_date — datetime
- pricing_type — varchar(45)
- contract_status — varchar(45)
- conditions — text
- reg_date — datetime
- close_date — varchar(45)
- cancel_reason — varchar(45)
credit_cards
- user_key — varchar(45) — Primary key — NOT NULL
- card_no — varchar(45) — Primary key — NOT NULL
- expiry_date — varchar(45)
- holder_name — varchar(45)
- verified_yn — varchar(2)
- phone_no — varchar(45)
- reg_date — datetime
job_area
- job_key — varchar(45) — Primary key — NOT NULL
- zip_code — varchar(45)
- address — varchar(45)
- location_x — double
- location_y — double
- reg_date — datetime
job_attachments
- job_key — varchar(45) — Primary key — NOT NULL
- attachment_name — varchar(45)
- attachment_url — varchar(45)
- attachment_type — varchar(45)
- reg_date — datetime
job_keywords
- job_key — varchar(45) — Primary key — NOT NULL
- keyword_key — varchar(45)
job_read_his
- job_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45)
- reg_date — datetime
jobs
- job_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45)
- job_title — varchar(45)
- job_desc — varchar(45)
- expiry_date — varchar(45)
- price — double
- pricing_role — varchar(45) — Fix, hourly
- job_status — varchar(45) — Open , closed
- update_time — datetime
- close_reason — varchar(45) — Close reason
- reg_date — varchar(45)
keywords
- keyword_key — varchar(45) — Primary key — NOT NULL
- keyword_group — varchar(45)
- keyword — varchar(45)
- reg_date — datetime
proposals
- proposal_key — varchar(45) — Primary key — NOT NULL
- job_key — varchar(45)
- user_key — varchar(45)
- price — varchar(45)
- message — varchar(45)
- proposal_status — varchar(45) — Request , rejected
- pricing_type — varchar(45) — Hourly , fixed
- read_yn — char(1) — If client opened it \n
- reg_date — datetime
rate_master
- rate_id — varchar(45) — Primary key — NOT NULL
- name — varchar(45)
- description — varchar(45)
- lan — varchar(2)
- use_yn — varchar(2)
- reg_time — datetime
rating
- owner_key — varchar(45) — Primary key — NOT NULL
- job_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45) — Primary key — NOT NULL
- rate_id — varchar(45) — Primary key — NOT NULL
- rate_value — varchar(45)
- use_yn — char(2)
- reg_date — varchar(45)
reviews
- owner_key — varchar(45) — Primary key — NOT NULL
- job_key — varchar(45) — Primary key — NOT NULL
- user_key — varchar(45) — Primary key — NOT NULL
- review — varchar(45)
- use_yn — char(2)
- flagged_yn — char(2)
- reg_date — varchar(45)
user_auth
- user_key — varchar(45) — Primary key — NOT NULL
- user_token — varchar(45)
- push_token — varchar(45)
- reg_date — varchar(45)
- expire_date — varchar(45)
user_bank_acc
- user_key — varchar(45) — Primary key — NOT NULL
- account_no — varchar(45) — Primary key — NOT NULL
- bank_name — varchar(45)
- reg_date — varchar(45)
users
- user_key — varchar(45) — Primary key — NOT NULL
- password — varchar(45)
- user_id — varchar(45)
- lan — varchar(2)
- user_email — varchar(45)
- first_name — varchar(45)
- last_name — varchar(45)
- mobile_number — varchar(45)
- verified_yn — char(1)
- create_date — datetime
- user_role — varchar(45) — Admin, user , agent
- user_type — varchar(45) — Agent , client , admin\n
- blocked_yn — varchar(45)
- reg_date — datetime
- modify_date — datetime
- reg_mothod — varchar(45) — Type of register : Facebook, gmail ..etc
- device_id — varchar(45) — Mobile device id
- device_os — varchar(2)
version
- os — varchar(1) — Primary key — NOT NULL
- min — varchar(45)
- current — varchar(45)
watch_list
- user_key — varchar(45) — Primary key — NOT NULL
- keyword — varchar(45)
- reg_date — varchar(45)