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