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