jobfinding
Tables (4)
CATEGORY (category)
- Id (id) — BIGINT(20) — Primary key — NOT NULL
- Id (id2) — BIGINT(20) — Foreign key → USER.Id — NOT NULL
- Name (name) — VARCHAR(255)
Company (company)
- Id (id) — BIGINT(20) — Primary key — NOT NULL
- Id (id2) — BIGINT(20) — Foreign key → CATEGORY.Id — NOT NULL
- Id (id22) — BIGINT(20) — Foreign key → CATEGORY.Id — NOT NULL
- Name (name) — VARCHAR(255)
- Description (description) — VARCHAR(255)
- Location (location) — VARCHAR(255)
Resume
- Key (id) — BIGINT(20) — Primary key — NOT NULL
- Id (id2) — BIGINT(20) — Foreign key → USER.Id — NOT NULL
- Field (uploadfile) — VARCHAR(255)
- Field (description) — VARCHAR(255)
USER (user)
- Id (id) — BIGINT(20) — Primary key — NOT NULL
- UserName (userName) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Email (email) — VARCHAR(255)