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)