company matching
Tables (8)
address
- address_id — INT — Primary key — NOT NULL
- city — VARCHAR(10)
- district — VARCHAR(20)
- street — VARCHAR(20)
- latitude — DECIMAL
- longitude — DECIMAL
career_history
- record_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id
- comp_id — INT — Foreign key → company.comp_id
- startdate — DATE
- enddate — DATE
company
- comp_id — INT — Primary key
- industry_id — INT — Foreign key → industry.industry_id — NOT NULL
- comp_name — VARCHAR(20)
current_job
- current_job_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id
- comp_id — INT — Foreign key → company.comp_id
- jobgroup_id — INT — Foreign key → jobgroup.jobgroup_id — NOT NULL
industry
- industry_id (indusrty_id) — INT — Primary key — NOT NULL
- industry_name — VARCHAR(20)
jobgroup
- jobgroup_id — INT — Primary key — NOT NULL
- jobgroup_name — VARCHAR(20)
tutor
- tutor_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id
- rating — DECIMAL
user
- user_id — INT — Primary key
- address_id — INT — Foreign key → address.address_id — NOT NULL
- preferred_industry_id (preferred_indusrty_id) — INT — Foreign key → industry.industry_id — NOT NULL
- preferred_jobgroup_id — INT — Foreign key → jobgroup.jobgroup_id — NOT NULL
- name — VARCHAR(20)
- gender — VARCHAR(2)
- univ_name — VARCHAR(20) — NOT NULL
- degree — VARCHAR(20)
- toeic — INT
- GPA — DECIMAL
- certificate — INT
- working_ysno — VARCHAR(2)