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