salarying

Tables (11)

Corp (Untitled)

  • ID (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • tel (Field2) — String
  • password (Field3) — password
  • sign-up-date (Field4) — DATE
  • Status (Field5)
  • email (Field6)

Corp-PW (Untitled2)

  • ID (Key) — Long — Primary key — NOT NULL
  • corp_id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
  • pw1 (Field2) — String
  • pw2 (Field3) — String
  • pw3 (Field4) — String
  • sign-in-date (Field) — Date

Employee (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • corp_id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
  • name (Field) — String
  • tel (Field2) — String
  • email (Field3)

Private (Untitled8)

  • ID (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • tel (Field2) — String
  • password (Field3) — String
  • email (Field4)

Q&A (Untitled12)

  • ID (Key) — Long — Primary key — NOT NULL
  • recruit_Id (Key2) — Long — Foreign key → recruit.ID — NOT NULL
  • corp_id (Key22) — Long — Foreign key → recruit.corp_id — NOT NULL
  • private_Id (Key3) — Long — Foreign key → Private.ID — NOT NULL
  • content (Field) — String

Reply (Untitled13)

  • ID (Key3) — Long — Primary key — NOT NULL
  • Q&A_Id (Key) — Long — Foreign key → Q&A.ID — NOT NULL
  • recruit_Id (Key2) — Long — Foreign key → Q&A.recruit_Id — NOT NULL
  • corp_id (Key22) — Long — Foreign key → Q&A.corp_id — NOT NULL
  • ID (Key32) — Long — Foreign key → Q&A.private_Id — NOT NULL
  • answer (Field) — String

apply (Untitled11)

  • ID (Key) — Long — Primary key — NOT NULL
  • recruit_Id (Key2) — Long — Foreign key → recruit.ID — NOT NULL
  • corp_id (Key22) — Long — Foreign key → recruit.corp_id — NOT NULL
  • private_Id (Key3) — Long — Foreign key → Private.ID — NOT NULL
  • level (Field) — String
  • progress (Field2) — String
  • result (Field3) — Boolean

msg (Untitled7)

  • ID (Key3) — Long — Primary key — NOT NULL
  • ID (Key) — Long — Foreign key → recruit.ID — NOT NULL
  • corp_id (Key2) — Long — Foreign key → recruit.corp_id — NOT NULL

private_PW (Untitled9)

  • ID (Key) — Primary key — NOT NULL
  • private_Id (Key2) — Long — Foreign key → Private.ID — NOT NULL
  • pw1 (Field) — String
  • pw2 (Field2) — String
  • pw3 (Field3) — String
  • sign-in-date (Field4) — DATE

recruit (Untitled4)

  • ID (Key) — Long — Primary key — NOT NULL
  • corp_id (Key2) — Long — Foreign key → Corp.ID — NOT NULL
  • title (Field) — String
  • type (Field2) — String
  • payment (Field3) — String

script (Untitled10)

  • ID (Key) — Long — Primary key — NOT NULL
  • private_Id (Key2) — Long — Foreign key → Private.ID — NOT NULL
  • corp_Id (Key3) — Long — Foreign key → Corp.ID — NOT NULL