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