project
Tables (8)
Application (지원서 이력 테이블)
- application_id (Key) — Primary key — NOT NULL
- company_id (Field2)
- job_id (Field3)
- user_id (Field4)
- cdate (Field5)
- job_id (Key2) — Foreign key → Job.job_id — NOT NULL
C_address (회사 주소 테이블)
- address (Field)
- name (Field2)
- company_uuid (Key) — Foreign key → Company.company_uuid — NOT NULL
C_fund (회사 투자 정보 테이블)
- date (Field)
- round_type (Field2)
- raised (Field3)
- currency (Field4)
- company_uuid (Key) — Foreign key → Company.company_uuid — NOT NULL
Company (회사 정보 테이블)
- company_uuid (Key) — Primary key — NOT NULL
- cdate (Field)
- mdate (Field2)
- found_date (Field3)
- employee_count (Field4)
- view_count (Field5)
- follow_count (Field6)
- reference_count (Field7)
J_address (근무지 테이블)
- name (Field)
- address (Field2)
- job_id (Key2) — Foreign key → Job.job_id — NOT NULL
J_bookmark (채용공고 북마크 이력 테이블)
- cdate (Field)
- uesr_id (Field3)
- job_id (Key) — Foreign key → Job.job_id — NOT NULL
Job (채용공고 테이블)
- job_id (Key) — Primary key — NOT NULL
- company_uuid (Field)
- cdate (Field2)
- mdate (Field3)
- job_field (Field4)
- career_type (Field5)
- start_date (Field6)
- end_date (Field7)
- allow_remote (Field8)
- can_show_salary (Field9)
log (유저 로그 기록 테이블)
- user_id (Field)
- url (Field2)
- timestamp (Field3)
- date (Field4)
- response_code (Field5)
- method (Field6)