Catch Lion
Tables (3)
corporation (회사)
- corId (Key) — bigint — Primary key — NOT NULL
- name (Field1) — varchar(255)
- industry (Field2) — varchar(255)
- location (Field3) — varchar(255)
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
jobPosting (채용 공고)
- postId (Key) — bigint — Primary key — NOT NULL
- corId (Key2) — bigint — Foreign key → corporation.corId — NOT NULL
- title (Field) — varchar(255)
- career (Field2) — varchar(255)
- academicㅠackground (Field3) — varchar(255)
- employmentForm (Field4) — varchar(255)
- pay (Field5) — bigint
- deadLine (Field6) — date
- created_at (Field7) — datetime
- updated_at (Field8) — datetime
selfIntroduction (자소서)
- selfId (Key) — bigint — Primary key — NOT NULL
- postId (Key2) — bigint — Foreign key → jobPosting.postId — NOT NULL
- content (Field) — varchar(255)
- created_at (Field2) — datetime
- updated_at (Field3) — datetime