Matching
Tables (7)
address
- address_id — INT — Primary key — NOT NULL
- city — VARCHAR(10)
- district — VARCHAR(20)
- street — VARCHAR(20)
- latitude — DECIMAL
- longitude — DECIMAL
career_hitory (career_history)
- Key (record_ID) — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id
- Field (from) — DATE
- Field2 (to) — DATE
- Field
company
- comp_id (company_id) — INT — Primary key — NOT NULL
- industry_id — INT — Foreign key → industry.industry_id — NOT NULL
- jobgroup_id — INT — Foreign key → jobgroup.jobgroup_id — NOT NULL
- comp_name (company_name) — VARCHAR(20)
industry (Untitled5)
- industry_id (Key) — INT — Primary key — NOT NULL
- industry_name (Field) — VARCHAR(20)
jobgroup (Untitled6)
- jobgroup_id (Key) — INT — Primary key — NOT NULL
- jobgroup_name (Field) — 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
- name — VARCHAR(20)
- gender — BOOLEAN
- univ_name — VARCHAR(20) — NOT NULL
- degree — VARCHAR(20)
- toeic — INT
- GPA — DECIMAL
- certificate — INT
- working_ysno — BOOLEAN