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