IT Challenge

테이블 (10)

Admin (Untitled6)

  • AdminId (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Email (Field2)
  • Password (Field3)
  • CreateDate (Field4)
  • LastUpdateDate (Field5)

Company (Untitled3)

  • Company ID (Key) — 기본 키 — NOT NULL
  • CompanyName (Field)
  • Email (Field9)
  • Password (Field10)
  • Category (Field4)
  • Partner (Field5)
  • File (Field7)
  • CheckDate (Field6)
  • Status (Field8)
  • CreateDate (Field2)
  • LastUpdateDate (Field3)

ES (Untitled4)

  • ESId (Key) — 기본 키 — NOT NULL
  • UserID (WriterId) — 외래 키 → User.UserId — NOT NULL
  • Text (Field)
  • ProfileImg (Field3)
  • WriteDate (Field2)
  • LastUpdateDate (Field4)

Semina (CopyOfUntitled7)

  • SeminaId (Key) — 기본 키 — NOT NULL
  • AdminId (Key2) — 외래 키 → Admin.AdminId — NOT NULL
  • Id (OpenCompany) — 외래 키 → Company.Company ID — NOT NULL
  • Title (Field)
  • Category (Field2)
  • Text (Field3)
  • img (Field4)
  • link (Field5)
  • 締め切り日 (Field8)
  • Location (Field9)
  • LastUpdateDate (Field7)
  • WriteDate (Field6)

SeminaList (CopyOfUntitled5)

  • SeminaId (Key) — 외래 키 → Semina.SeminaId — NOT NULL
  • UserId (Key2) — 외래 키 → User.UserId — NOT NULL
  • 申込日 (Field)

TipBoard (Untitled7)

  • TipId (Key) — 기본 키 — NOT NULL
  • AdminId (WriterId) — 외래 키 → Admin.AdminId — NOT NULL
  • Title (Field)
  • Category (Field2)
  • Text (Field3)
  • img (Field4)
  • link (Field5)
  • WriteDate (Field6)
  • LastUpdateDate (Field7)

User (Untitled)

  • UserId (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • EngName (Field2)
  • Birth (Field3)
  • Location (Field5)
  • Email (Field7)
  • Password (Field8)
  • CreateDate (Field9)
  • LastUpdateDate (Field6)

求人公告 (Untitled2)

  • Id (Key) — 기본 키 — NOT NULL
  • CompanyWriter (WriterId) — 외래 키 → Company.Company ID — NOT NULL
  • Title (Field)
  • Category (Field6)
  • Text (Field2)
  • Img (Field4)
  • link (Field5)
  • 締め切り日 (Field8)
  • WriteDate (Field3)
  • LastUpdateDate (Field7)

申請リスト (Untitled5)

  • BorderID (Key) — 외래 키 → 求人公告.Id — NOT NULL
  • ESId (Key2) — 외래 키 → ES.ESId — NOT NULL
  • UserId (WriterId) — 외래 키 → ES.UserID — NOT NULL
  • 申込日 (Field)

이미지 분석 결과 (Untitled8)

  • Company ID (Key) — 외래 키 → Company.Company ID — NOT NULL
  • File (Field)
  • Percent (Field2)
  • FileCompanyName (Field3)
  • Notice (Field4)
  • Date (Field5)
  • Status (Field6)