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