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