Mini-Project

Tables (10)

Copy Of Untitled (like)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field2 (recruitment_id) — int
  • Field2 (count) — int

Untitled (enterprise)

  • Key (id) — int — Primary key — NOT NULL
  • Field (enterprise_name) — varchar(100)
  • Field (password) — varchar(100)
  • Field (address) — varchar(100)
  • Field (contact) — varchar(10)
  • Field (image) — longtext
  • Field (sector) — varchar(100)
  • Field (class) — varchar(100)
  • Field (created_at) — Timestamp

Untitled (resume)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field (title) — varchar(100)
  • Field (content) — longtext
  • Field (profile) — longtext
  • Field (age) — int
  • Field (address) — varchar(100)
  • Field (career) — varchar(100)
  • Field (education) — varchar(100)
  • Field (job_objectives(희망직종)) — varchar(30)
  • Field (created_at) — Timestamp
  • Field

Untitled (recruitment_post)

  • Key (id) — int — Primary key — NOT NULL
  • Key (enterprise_id) — int — NOT NULL
  • Field (title) — varchar(100)
  • Field (content) — varchar(100)
  • Field (enterprise_logo) — longtext
  • Field (created_at) — Timestamp
  • Field2 (address)

Untitled (bookmark)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field2 (enterprise_id) — int
  • Field2 (count) — int

Untitled (interest)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field (enterprise_id) — int
  • Field (picture) — varchar(200)
  • Field (user_interest) — varchar(100)
  • Field (enterprise_interest) — varchar(100)
  • Field

Untitled (suggest)

  • Key (id) — int — Primary key — NOT NULL
  • Field (enterprise_id) — int
  • Field (title) — varchar(100)
  • Field (content) — varchar(100)
  • Field

Untitled (suggest_detail)

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar(100)
  • Field (user_email) — varchar(100)
  • Field (user_career) — varchar(100)
  • Field (user_interest) — varchar(100)
  • Field

Untitled (apply)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — int
  • Field (enterprise_id) — int
  • Field (created_at) — Timestamp
  • Field

user

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar(100)
  • Field (password) — varchar(100)
  • Field (name) — varchar(50)
  • Field (email) — varchar(100)
  • Field (phone-number) — varchar(50)
  • Field (created_at) — Timestamp