job-posting-service

Tables (10)

DELETE_STEPUP_POSTING (CopyOfUntitled7)

  • 스텝업아이디 (STEPUP_POSTING_ID) — pk — Foreign key → STEPUP_POSTING.스텝업아이디 — NOT NULL
  • 사용자id (USER_ID) — pk — Foreign key → USER.사용자id — NOT NULL

DELETE_WANTED_POSTING (CopyOfUntitled62)

  • 원티드아이디 (WANTED_POSTING_ID) — pk — Foreign key → WANTED_POSTING.원티드아이디 — NOT NULL
  • 사용자id (USER_ID) — pk — Foreign key → USER.사용자id — NOT NULL

JOB_CLASS (Untitled3)

  • 직무분류id (JOB_CLASS_ID) — pk — Primary key — NOT NULL
  • 직무분류이름 (JOB_CLASS_NAME)

POSITION (Untitled2)

  • 직급id (POSITION_ID) — pk — Primary key — NOT NULL
  • 직급이름 (POSITION_NAME)

SCRAP_STEPUP_POSTING (Untitled7)

  • 스텝업아이디 (STEPUP_POSTING_ID) — pk — Foreign key → STEPUP_POSTING.스텝업아이디 — NOT NULL
  • 사용자id (USER_ID) — pk — Foreign key → USER.사용자id — NOT NULL

SCRAP_WANTED_POSTING (Untitled6)

  • 원티드아이디 (WANTED_POSTING_ID) — pk — Foreign key → WANTED_POSTING.원티드아이디 — NOT NULL
  • 사용자id (USER_ID) — pk — Foreign key → USER.사용자id — NOT NULL

STEPUP_POSTING (CopyOfUntitled)

  • 스텝업아이디 (STEPUP_POSTING_ID) — pk — Primary key — NOT NULL
  • 직무이름 (JOB_NAME)
  • 마감일 (DUE_DATE)
  • url (URL)
  • 기업이름 (CORPORATION_NAME)
  • 직급id (POSITION_ID) — pk — Foreign key → POSITION.직급id — NOT NULL

USER (Untitled5)

  • 사용자id (USER_ID) — pk — Primary key — NOT NULL

WANTED_POSTING (Untitled)

  • 원티드아이디 (WANTED_POSTING_ID) — pk — Primary key — NOT NULL
  • 직무이름 (JOB_NAME)
  • 마감일 (DUE_DATE)
  • url (URL)
  • 섬네일링크 (THUMB_LINK)
  • 기업이름 (CORPORATION_NAME)

WANTED_POSTING_JOB_CLASS_RELATION (Untitled4)

  • 직무분류id (JOB_CLASS_ID) — pk — Foreign key → JOB_CLASS.직무분류id — NOT NULL
  • 원티드아이디 (WANTED_POSTING_ID) — pk — Foreign key → WANTED_POSTING.원티드아이디 — NOT NULL