scp
Tables (12)
chatinuser
- 채팅내유저 (chatinuser_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 채팅방ID (chatroom_id) — bigint — Foreign key → chatroom.채팅방ID — NOT NULL
- 채팅리더 (chatinuser_commoncode) — varchar(20)
- 퇴장여부 (chatinuser_exit) — boolean
chatroom
- 채팅방ID (chatroom_id) — bigint — Primary key — NOT NULL
- 채팅방이름 (chatroom_name) — varchar(50) — NOT NULL
- 채팅방코드(권한) (chatroom_commoncode) — varchar(20) — NOT NULL
comment
- 댓글ID (comment_id) — bigint — Primary key — NOT NULL
- 할일ID (task_id) — bigint — Foreign key → task.할일ID — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 할일작성일시 (comment_time) — datetime — NOT NULL
- 할일내용 (comment_content) — varchar(255) — NOT NULL
common (userCode)
- 공통코드 (common_code) — Primary key — NOT NULL
- 상위공통코드 (parent_code) — Foreign key → common.공통코드
- 코드 명 (common_name) — NOT NULL
- 코드 설명 (common_exp)
- 등록 일시 (common_registertime) — NOT NULL
file
- 파일ID (file_id) — bigint — Primary key — NOT NULL
- 할일ID (task_id) — bigint — Foreign key → task.할일ID — NOT NULL
- 파일이름 (file_name) — varchar(50) — NOT NULL
- 파일사이즈 (file_size) — bigint — NOT NULL
- 파일경로 (file_path) — varchar(255) — NOT NULL
- 파일확장자 (file_extension) — varchar(10)
message
- 메세지ID (message_id) — bigint — Primary key — NOT NULL
- 채팅내유저 (chatinuser_id) — bigint — Foreign key → chatinuser.채팅내유저 — NOT NULL
- 메세지내용 (message_content) — varchar(255) — NOT NULL
- 메세지작성시간 (message_time) — datetime — NOT NULL
project
- 프로젝트ID (project_id) — bigint — Primary key — NOT NULL
- 프로젝트이름 (project_name) — varchar(50) — NOT NULL
- 채팅방ID (chatroom_id) — bigint — Foreign key → chatroom.채팅방ID — NOT NULL
projectinuser
- 프로젝트내유저ID (projectinuser_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 프로젝트ID (project_id) — bigint — Foreign key → project.프로젝트ID — NOT NULL
- 프로젝트내유저공통코드(권한) (projectinuser_commoncode) — varchar(20) — NOT NULL
- 프로젝트개설자 (projectinuser_maker) — boolean — NOT NULL
task
- 할일ID (task_id) — bigint — Primary key — NOT NULL
- 프로젝트내유저ID (projectinuser_id) — bigint — Foreign key → projectinuser.프로젝트내유저ID — NOT NULL
- 할일내용 (task_content) — varchar(255) — NOT NULL
- 할일요청자 (task_requester) — bigint — NOT NULL
- 할일해결여부 (task_complete) — boolean — NOT NULL
- 할일수락여부 (task_accept) — boolean — NOT NULL
- 할일요청일자 (task_request_time) — datetime — NOT NULL
- 할일마감일자 (task_deadline) — datetime — NOT NULL
- 할일생성일자 (task_createtime) — datetime — NOT NULL
team
- 팀ID (team_id) — bigint — Primary key — NOT NULL
- 팀이름 (team_name) — varchar(50) — NOT NULL
- 채팅방ID (chatroom_id) — bigint — Foreign key → chatroom.채팅방ID — NOT NULL
teaminuser
- 팀내유저ID (teaminuser_id) — bigint — Primary key — NOT NULL
- 유저ID (user_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 팀ID (team_id) — bigint — Foreign key → team.팀ID — NOT NULL
- 팀내유저공통코드(권한) (teaminuser_commoncode) — varchar(20) — NOT NULL
- 팀개설자 (teaminuser_maker) — boolean — NOT NULL
user
- 유저ID (user_id) — bigint — Primary key — NOT NULL
- 유저닉네임 (user_nickname) — varchar(20) — NOT NULL
- 유저이메일 (user_email) — varchar(255) — NOT NULL
- 유저SNS타입 (user_snstype) — varchar(255) — NOT NULL
- 유저권한 (user_role) — varchar(20) — NOT NULL