test

Tables (9)

ADVICE_BOARD

  • advice_board_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • kind — VARCHAR(255) — NOT NULL

ADVICE_BOARD_REPLY

  • advice_board_id — int — Foreign key → ADVICE_BOARD.advice_board_id — NOT NULL
  • user_id — int — Foreign key → ADVICE_BOARD.user_id — NOT NULL
  • nickname — VARCHAR(255)
  • content — VARCHAR(255)
  • parent_reply_id — VARCHAR(255)
  • state — VARCHAR(255)

JOB_POST

  • job_post_id — int — Primary key — NOT NULL
  • vender_id — int — Primary key — NOT NULL
  • job_post_temp_id — int — Foreign key → JOB_POST_TEMP.job_post_temp_id — NOT NULL
  • job_post_title — varchar(100) — NOT NULL
  • job_post_detail — varchar(3000) — NOT NULL
  • job_post_work — varchar(100) — NOT NULL
  • job_post_req — varchar(100)
  • job_post_salary — varchar(100)
  • job_post_addr — varchar(100) — NOT NULL
  • job_post_endtime — datetime(6) — NOT NULL
  • job_post_postdate — datetime(6)
  • job_post_state — varchar(20) — NOT NULL
  • job_post_div — varchar(20)

JOB_POST_TEMP

  • job_post_temp_id — int — Primary key — NOT NULL
  • vender_id — int — Foreign key → VENDER.vender_id — NOT NULL
  • job_post_temp_title — varchar(100) — NOT NULL
  • job_post_temp_detail — varchar(3000) — NOT NULL
  • job_post_temp_work — varchar(100) — NOT NULL
  • job_post_temp_req — varchar(100)
  • job_post_temp_salary — varchar(100)
  • job_post_temp_addr — varchar(100) — NOT NULL
  • job_post_temp_endtime — datetime(6) — NOT NULL
  • job_post_temp_postdate — datetime(6)
  • job_post_temp_state — varchar(20) — NOT NULL
  • job_post_temp_div — varchar(20)
  • job_post_temp_reqstate — varchar(20)

JP_APPLY

  • Key — int — Primary key — NOT NULL
  • vender_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • job_post_id — int — Foreign key → JOB_POST.job_post_id — NOT NULL
  • job_post_temp_id — int — Foreign key → JOB_POST.job_post_temp_id — NOT NULL
  • like_date — VARCHAR(255)

JP_LIKE

  • Key — int — Primary key — NOT NULL
  • vender_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • job_post_id — int — Foreign key → JOB_POST.job_post_id — NOT NULL
  • job_post_temp_id — int — Foreign key → JOB_POST.job_post_temp_id — NOT NULL
  • like_date — VARCHAR(255) — NOT NULL

USER

  • user_id — int — Primary key — NOT NULL
  • user_email — varchar(40) — NOT NULL
  • user_name — varchar(30) — NOT NULL
  • passwd — varchar(100) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • birth — varchar(20)
  • privacy_state — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • state — varchar(20)

USER_RESUME

  • user_resume_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • addr_num — varchar(20) — NOT NULL
  • addr_basic — varchar(200) — NOT NULL
  • addr_detail — varchar(200) — NOT NULL
  • skill — varchar(1000)
  • final_education — varchar(200) — NOT NULL
  • state_resume — varchar(20) — NOT NULL
  • state_contact — varchar(20) — NOT NULL
  • certificattion — VARCHAR(255)
  • work_exp — VARCHAR(255)
  • training — VARCHAR(255)
  • extracurricular — _activities`
  • accomplishment — VARCHAR(255)
  • overseas_exp — VARCHAR(255)
  • language_skill — VARCHAR(255)
  • portfolio — VARCHAR(255)
  • git_addr — VARCHAR(255)
  • military — _service`
  • resume_title_1 — varchar(1000) — NOT NULL
  • resume_content_1 — varchar(3000) — NOT NULL
  • photo — VARCHAR(255)

VENDER

  • vender_id — int — Primary key — NOT NULL
  • vender_email — VARCHAR(255) — NOT NULL
  • vender_name — VARCHAR(255) — NOT NULL
  • vender_passwd — VARCHAR(255) — NOT NULL