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