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)