recruit
Tables (15)
Admin (Untitled4)
- ID (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- type (Field2) — String
- pw (Field3) — String
- email (Field4) — String
- sign-in-Date (Field5) — Date
- change-pw-date (Field6) — Date
Apply (Untitled3)
- ID (Key) — Long — Primary key — NOT NULL
- recruit_Id (Key2) — Long — Foreign key → recruit.ID — NOT NULL
- name (Field) — String
- email (Field2) — String
- tel (Field3) — String
- progress (Field4) — String
- status (Field5) — String
CS (Untitled13)
- ID (Key) — Long — Primary key — NOT NULL
- corp_Id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
- title (Field)
- content (Field2)
- Date (Field3) — Date
CS-reply (Untitled14)
- ID (Key) — Long — Primary key — NOT NULL
- CS_Id (Key2) — Long — Foreign key → CS.ID — NOT NULL
- owner_Id (Key3) — Long — Foreign key → Admin.ID — NOT NULL
- answer (Field) — String
- Date (Field2) — Date
Corp (Untitled)
- ID (Key) — Long — Primary key — NOT NULL
- owner_Id (Key2) — Long — Foreign key → Admin.ID — NOT NULL
- name (Field) — String
- tel (Field3) — String
- last-sign-in (Field4) — Date
- pw (Field5) — String
- status (Field6) — String
- type (Field7) — String
- emaili (Field2) — String
Corp PW (Untitled10)
- ID (Key) — Long — Primary key — NOT NULL
- corp_Id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
- ID (Key22) — Long — Foreign key → Corp.owner_Id — NOT NULL
- pw1 (Field) — String
- pw2 (Field2) — String
- pw3 (Field3) — String
Email (Untitled8)
- Id (Key) — Long — Primary key — NOT NULL
- apply_Id (Key2) — Long — Foreign key → Apply.ID — NOT NULL
- Date (Field2) — Date
- status (Field3) — status
FAQ (Untitled12)
- ID (Key) — Long — Primary key — NOT NULL
- owner_Id (Key2) — Long — Foreign key → Admin.ID — NOT NULL
- question (Field) — String
- answer (Field2) — String
- Date (Field3) — Date
Owner PW (Untitled9)
- ID (Key) — Long — Primary key — NOT NULL
- owner_Id (Key2) — Long — Foreign key → Admin.ID — NOT NULL
- pw1 (Field) — String
- pw2 (Field2) — String
- pw3 (Field3) — String
- pw1-Date (Field4) — Date
- pw2-Date (Field5) — Date
- pw3-Date (Field6) — Date
agreement (Untitled5)
- ID (Key) — Long — Primary key — NOT NULL
- category_Id (Key2) — Long — Foreign key → category.ID — NOT NULL
- owner_Id (Key3) — Long — Foreign key → Admin.ID — NOT NULL
- content (Field2) — Long
- version (Field3) — Float
- Status (Field4) — String
- title (Field) — String
announce (Untitled11)
- ID (Key) — Long — Primary key — NOT NULL
- owner_Id (Key2) — Long — Foreign key → Admin.ID — NOT NULL
- title (Field) — String
- content (Field2) — String
- Date (Field3) — Date
category (Untitled6)
- ID (Key) — Long — Primary key — NOT NULL
- type (Field) — String
employee (Untitled2)
- ID (Key) — Primary key — NOT NULL
- corp_Id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
- name (Field) — String
- email (Field2) — String
- tel (Field3) — String
- Status (Field4) — String
progress (Untitled15)
- progress_Id (Key) — Long — Primary key — NOT NULL
- recruit_Id (Key2) — Long — Foreign key → recruit.ID — NOT NULL
- document (Field) — boolean
- first step (Field2) — boolean
- second step (Field3) — boolean
- final step (Field4) — boolean
recruit (Untitled7)
- ID (Key) — Long — Primary key — NOT NULL
- corp_Id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
- Date (Field2) — Date
- title (Field3) — String
- task (Field4) — String
- Status (Field5) — String