02-DB Design - project management part

하고 싶은 것

1. 프로젝트 관리 및 통계 데이터 만들어내기

name , stack , intro , content , startDate , endDate (#### , ## , ##)

role , Realization , Improvement points , purpose

table

name 목적

project	대단위 프로젝트 설정 정보 관리
tech_stack	테크 스택 관리
project_tech_stack	프로젝트별 테크 스택 관리
role	담당 롤 관리
project_role	프로젝트별 롤 관리
project_content	프로젝트 별 내용 관리

ERD

 

 

 

detail table design

ETC_관리

ETC Name 설명

PK	primary Key
un	유니크
N	Null able - 없는 경우 NN (defalut)
FK(from)	외래키 (프롬)

project_t

name structure size option etc

idx	Long		AI	pk
name	varchar	30		un
main_image	LongBlob
intro	varchar	50
start_date	DATE	#### - ## - ##
end_date	DATE	#### - ## - ##
realization	varchar	200		N
improvement_point	varchar	200		N
purpose	varchar	50		N
created_date	TimeStamp
last_update_date	TimeStamp
delete_flag	boolean

tech_stack_t

name structure size option etc

name	varchar	50		pk , un
icon	LongBlob
created_date	TimeStamp
last_update_date	TimeStamp
delete_flag	boolean

role_t

name structure size option etc

name	varchar	50		pk , un
content	varchar	30
created_date	TimeStamp
last_update_date	TimeStamp
delete_flag	boolean

project_teck_stack_t

name structure size option etc

idx	Long		AI	pk
project_idx	FK(Long)			FK (project)
teck_stack_name	FK(varchar)			FK(tech_stack)
create_date	TimeStamp

project_role_t

name structure size option etc

idx	Long		AI	pk
project_idx	FK(Long)			FK (project)
role_name	FK(varchar)			FK(role)
create_date	TimeStamp

project_content_t

name structure size option etc

idx	Long		AI	pk
project_idx	FK(Long)			FK (project)
sub_heading	varchar	20
content	varchart	200
content_img	LongBlob			N
created_date	TimeStamp
last_update_date	TimeStamp