JasoseolSelf
Tables (10)
announcement (Untitled2)
- id (Key) — Primary key — NOT NULL
- company_id (Key2) — Foreign key → company.COMPANY_ID — NOT NULL
- start_day (Field) — DATETIME
- end_day (Field5) — DATETIME
- clicked (Field2)
- bookmark (Field3)
- visited (Field4)
- id (Key3) — Foreign key → user_bookmark.BOOKMARK_ID — NOT NULL
- user_id (Key22) — Foreign key → user_bookmark.user_id — NOT NULL
- ANNOUNCEMENT_TITLE (Field6) — STRING
announcement_details (Untitled3)
- announcement_details_id (Key) — Primary key — NOT NULL
- announcement_id (Key2) — Foreign key → announcement.id — NOT NULL
- company_id (Key22) — Foreign key → announcement.company_id — NOT NULL
- TYPE (Field) — int
- CONTENT (Field2)
- WRITERS_COUNT (Field3) — 자소서 작성자 수
- BIG_CATEGORY (Field5)
- MIDDLE_CATEGORY (Field6)
- SMALL_CATEGORY (Field4)
company (Untitled)
- COMPANY_ID (Key) — Primary key — NOT NULL
- COMPANY_NAME (Field)
- SITE (Field2)
- COMPANY_TYPE (Field3)
- OWNER (Field4)
- EMPLOYEE (Field5)
- SALES (Field6)
- ESTABLISHMENT (Field7)
- ADDRESS (Field8)
- ANNUAL_INCOME (Field9)
company_user (Untitled13)
- USER_ID (Key2) — Foreign key → user.USER_ID — NOT NULL
- COMPANY_ID (Key) — Foreign key → company.COMPANY_ID — NOT NULL
- COMPANY_NUM (Field3)
- COMPANY_USER_NAME (Field4)
- COMPANY_USER_PHONENUM (Field5)
image (Untitled11)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → announcement.id — NOT NULL
- company_id (Key22) — Foreign key → announcement.company_id — NOT NULL
- IMAGE_URL (Field2)
- use (Field3) — bool
- main (Field) — bool
interested_company (Untitled9)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.USER_ID — NOT NULL
- company_id (Key3) — Foreign key → company.COMPANY_ID — NOT NULL
question (Untitled12)
- question_id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → announcement_details.announcement_details_id — NOT NULL
- announcement_id (Key22) — Foreign key → announcement_details.announcement_id — NOT NULL
- company_id (Key222) — Foreign key → announcement_details.company_id — NOT NULL
- QUESTION (Field) — String
- LETTER (Field2) — INT
study (Untitled8)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.USER_ID — NOT NULL
- last_study (Field)
- school_name (Field2)
- major (Field3)
- entrance (Field4) — DATETIME
- graduate (Field5) — DATETIME
user (Untitled7)
- USER_ID (Key) — Primary key — NOT NULL
- EMAIL (Field)
- PASSWORD (Field5)
- NICKNAME (Field2)
- MARKETING (Field9)
- career (Field4)
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATETIME
- deleted_at (Field8) — DATETIME
- ROLE (Field10)
user_bookmark (Untitled10)
- BOOKMARK_ID (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.USER_ID — NOT NULL