dev09

Tables (19)

Untitled (dev_emp_list)

  • Key (dev_emp_list_id) — not null — Primary key — NOT NULL
  • Key (dev_employment_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (comp_name) — null
  • Field2 (comp_dept) — null
  • Field3 (comp_pos) — null
  • Field4 (comp_term) — null

Untitled (dev_certificate)

  • Key (dev_certificate_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — not null

Untitled (dev_employment)

  • Key (dev_employment_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (taskDesc) — null
  • Field2 (status) — not null

Untitled (Doc)

  • Key (doc_id) — not null — Primary key — NOT NULL
  • Field (doc_name) — not null
  • Field2 (doc_type) — not null
  • Field3 (file_download_uri) — not null
  • Field4 (doc_size) — not null
  • Field5 (doc_path) — not null
  • Field2 (post_id) — not null
  • Field (table_name) — not null

Untitled (dev_indu_category)

  • Key (dev_indu_category_id) — not null — Primary key — NOT NULL
  • Key (dev_portfolio_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (industry_category_code_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (dev_indu_category_code) — not null
  • Field (dev_indu_category_name) — not null

Untitled (dev_proj_category)

  • Key (dev_proj_category_id) — not null — Primary key — NOT NULL
  • Key (dev_portfolio_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (project_category_code_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (dev_proj_category_code) — not null
  • Field (dev_proj_category_name)

Untitled (project_category_code)

  • Key (project_category_code_id) — not null — Primary key — NOT NULL
  • Field (project_category_code) — not null
  • Field2 (project_category_name) — not null

Untitled (industry_category_code)

  • Key (industry_category_code_id) — not null — Primary key — NOT NULL
  • Field (industry_category_code) — not null
  • Field2 (industry_category_name) — not null

Untitled (dev_certificate_list)

  • Key (dev_certificate_list_id) — not null — Primary key — NOT NULL
  • Key (dev_certificate_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (certificate_name) — null
  • Field2 (certificate_auth) — null
  • Field3 (certificate_date) — null
  • Field4 (certificate_num) — null

Untitled (dev_education)

  • Key (dev_education_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (edu_class) — null
  • Field (edu_state) — null
  • Field (school_in) — null
  • Field2 (school_out) — null
  • Field3 (school_name) — null
  • Field4 (school_major) — null
  • Field (status) — not null

Untitled (user)

  • Key (user_id) — not null — Primary key — NOT NULL
  • Field (email) — not null
  • Field (password) — not null
  • Field2 (name) — not null
  • Field3 (phone_num) — null
  • Field4 (locale) — null
  • Field (role) — not null
  • Field2 (person_agree) — not null
  • Field (authkey) — null
  • Field2 (authstatus) — not null

Untitled (skill_class)

  • (skill_class_id) — not null — Primary key — NOT NULL
  • Key (dev_skill_desc_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (skill_class_code_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (dev_skill_class_code) — not null
  • Field (dev_skill_class_name) — not null
  • Field2 (dev_skill_class_level) — not null
  • Field3 (dev_skill_class_career) — not null

Untitled (skilll_category)

  • Key (skill_category_id) — not null — Primary key — NOT NULL
  • Key (dev_skill_desc_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Key (project_category_code_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (dev_skill_category_code) — not null
  • Field (dev_skill_category_name) — not null

Untitled (dev_project)

  • Key (dev_project_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (proj_catch) — null
  • Field2 (proj_name) — null
  • Field3 (proj_rate) — null
  • (proj_term) — null
  • (proj_order) — null
  • Field (proj_img_path) — null

Untitled (skill_class_code)

  • Key (skill_class_code_id) — not null — Primary key — NOT NULL
  • Field (skill_class_code) — not null
  • Field2 (skill_class_name) — not null

Untitled (dev_skill_desc)

  • Key (dev_skill_desc_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — not null

Untitled (dev_portfolio)

  • Key (dev_portfolio_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (proj_role) — not null
  • Field4 (proj_desc) — null
  • Field (status) — not null

Untitled (dev_introduction)

  • Key (dev_introduction_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (buss_type) — null
  • Field2 (work_type) — null
  • Field3 (prof_catch) — not null
  • Field4 (prof_desc) — null
  • Field (status) — not null

Untitled (user_acc)

  • Key (user_acc_id) — not null — Primary key — NOT NULL
  • Key (user_id) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (acc_bankname) — not null
  • Field2 (acc_code) — not null
  • Field3 (acc_email) — not null
  • Field4 (acc_num) — not null