이력서 플랫폼 웹사이트 프로그램

 

1. 깃허브

https://github.com/TrainingScav/portfolio_html_css_pratice_project

GitHub - TrainingScav/portfolio_html_css_pratice_project

 

 

2. ERD다이어그램

 

 

3. 테이블 명세서

이력서_플랫폼_프로그램_테이블_정의서_v_01.xlsx

0.02MB

 

 

4. 테이블 설계

-- 스키마 정보
create database resume;

-- 회원정보
create table user_info (
user_id int auto_increment primary key,
user_login_id varchar(50) not null,
name varchar(50) not null,
password varchar(30) not null
);

-- 이력서 정보
-- 테이블_id, 회원 키(참조), 이메일, 생년월일, 휴대폰 번호, 주소, 개발직무, 기술스텍, 경력여부(true or false)
create table user_portfolio_info(
    portfolio_id int auto_increment primary key,
    user_id int not null,
    email varchar(100) not null,
    birth_date varchar(8) not null,
    phone_number varchar(15) not null,
    address varchar(100) not null,
    user_develope_type varchar(100) not null,
    user_skill_stack varchar(100) not null,
    isWorked boolean not null,
    constraint fk_user_id foreign key (user_id) references user_info(user_id)
);

-- 제휴문의
-- 이름,연락처,이메일,회사(직장),부서명,직함,제목,내용,파일(???)
create table partnership_inquiry(
    p_inquiry_id int primary key auto_increment,
    user_id int not null,
    name varchar(10) not null,
    phone_number varchar(15) not null,
    email varchar(50) not null,
    company varchar(50) not null,
    dept varchar(50) not null,
    position varchar(50),
    file_url varchar(200),
    file_name varchar(200),
    inq_title varchar(100) not null,
    inq_content text not null,
    constraint fk_partnership_user_id foreign key (user_id) references user_info(user_id)
);

-- 고객문의
-- 테이블ID, user_id, inquiry_password, title, content, file_url, file_name
create table customer_inquiry(
    c_inquiry_id int primary key auto_increment,
    user_id int not null,
    inquiry_password varchar(20) not null,
    inq_title varchar(100) not null,
    inq_content text not null,
    file_url varchar(200),
    file_name varchar(200),
    constraint fk_customer_user_id foreign key (user_id) references user_info(user_id)
);

-- 공지사항
-- 공지사항ID, 분류, 제목, 작성자, 작성일
 create table notice(
    notice_id int primary key auto_increment,
    notice_type varchar(20) not null,
    title varchar(100) not null,
    content text not null,
    inst_id varchar(100),
    inst_date timestamp default CURRENT_TIMESTAMP
);