AYA
Tables (4)
Application Table (Untitled4)
- Columns (Key) — Primary key — NOT NULL
- Colums (Key2) — Foreign key → Job Table.Colums — NOT NULL
- Columns (Key22) — Foreign key → Job Table.Columns — NOT NULL
- Columns (Key3) — Foreign key → User Table:.Columns — NOT NULL
- application_id (Primary Key)
- job_id (Foreign Key referencing Job Table)
- candidate_id (Foreign Key referencing User Table)
- status (pending, accepted, rejected)
Company Table (Untitled3)
- Columns (Key) — Primary key — NOT NULL
- company_id (Primary Key)
- name (Field2)
- industry (Field3)
- size (Field4)
Job Table (Untitled2)
- Colums (Key) — Primary key — NOT NULL
- Columns (Key2) — Foreign key → Company Table.Columns — NOT NULL
- job_id (Primary Key)
- title (Field2)
- description (Field3)
- salary (Field4)
- location (Field5)
- company_id (Foreign Key referencing Company Table)
- posted_by (Foreign Key referencing User Table)
User Table: (Untitled)
- Columns (Key) — Primary key — NOT NULL
- user_id (Primary Key)
- username (Field2)
- email (Field3)
- password (Field4)
- role (employer or candidate)