Taskgram

Tables (17)

CHATTING (채팅)

  • chatting_id (PK) — bigint — Primary key — NOT NULL
  • chattingRoom_id (Key2) — Foreign key → CHATTINGROOM.chattingRoom_id — NOT NULL
  • user_id (Key) — bigtint — Foreign key → USER.user_id — NOT NULL
  • contend (Field) — string — NOT NULL

CHATTINGROOM (채팅방)

  • chattingRoom_id (PK) — bigint — Primary key — NOT NULL
  • project_id (Key) — NOT NULL — Foreign key → PROJECT.project_id — NOT NULL

CHATTINGROOM_MEMBER (채팅방에 참여한 멤버 다대다 관계)

  • chattingRoom_member_id (PK) — bigint — Primary key — NOT NULL
  • chattingRoom_id (Key) — Foreign key → CHATTINGROOM.chattingRoom_id — NOT NULL
  • user_id (Key2) — bigtint — Foreign key → USER.user_id — NOT NULL

COMMENT (댓글)

  • commend_id (PK) — NOT NULL — Primary key — NOT NULL
  • user_id (유저 PK) — bigtint — Foreign key → USER.user_id — NOT NULL
  • issue_id (이슈 PK) — bigint — Foreign key → ISSUE.issue_id — NOT NULL
  • content (내용) — text — NOT NULL
  • update_date (수정 날짜) — datetime — NOT NULL

ISSUE (이슈)

  • issue_id (PK) — bigint — Primary key — NOT NULL
  • task_id (테스크 PK) — bigint — Foreign key → TASK.task_id — NOT NULL
  • creator_id (작성자 PK) — bigtint — Foreign key → USER.user_id — NOT NULL
  • manager_id (담당자 PK) — bigtint — Foreign key → USER.user_id — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • content (내용) — text — NOT NULL
  • modify_date (수정 날짜) — datetime — NOT NULL
  • start_date (이슈 시작 날짜) — datetime — NOT NULL
  • end_date (이슈 종료 날짜) — datetime — NOT NULL
  • status (상태) — varchar(20) — NOT NULL — ENUM

ISSUE_STATUS (issue의 상태 다대다 관계)

  • issue_status_id (PK) — bigtint — Primary key — NOT NULL
  • content (상태) — varchar(20) — NOT NULL — ENUM

PROFILE (Untitled2)

  • profile_id (Key) — NOT NULL — Primary key — NOT NULL
  • Field

PROJECT (프로젝트)

  • project_id (PK) — bigint — Primary key — NOT NULL
  • owner_user_id (소유 user id) — bigtint — Foreign key → USER.user_id — NOT NULL
  • custom_url (커스텀 url) — varchar(100) — NOT NULL
  • banner_url (배너 url) — varchar(300)O
  • name (프로젝트 이름) — varchar(100) — NOT NULL
  • detail (세부 설명) — text
  • create_date (생성 날짜) — datetime — NOT NULL
  • start_date (시작 날짜) — datetime — NOT NULL
  • end_date (종료 날짜) — datetime — NOT NULL
  • is_public (공개 여부) — boolean — NOT NULL

PROJECT_MEMBER (프로젝트 참여한 유저 다대다 관계)

  • project_member_id (PK) — bigtint — Primary key — NOT NULL
  • user_id (FK) — bigtint — Foreign key → USER.user_id — NOT NULL
  • project_id (FK2) — bigint — Foreign key → PROJECT.project_id — NOT NULL

PROJECT_TAG (Untitled)

  • project_tag_id (PK) — bigtint — Primary key — NOT NULL
  • tag (태그 이름) — varchar(100) — NOT NULL
  • hex_code (Field) — varchar(8) — NOT NULL

STATUS (이슈 상태값 저장)

  • status_id (PK) — bigint — Primary key — NOT NULL
  • content (상태) — varchar(20) — NOT NULL

TAG (Untitled4)

  • tag_id (PK) — bigint — Primary key — NOT NULL

TASK (테스크)

  • task_id (PK) — bigint — Primary key — NOT NULL
  • project_id (PK2) — bigint — Foreign key → PROJECT.project_id — NOT NULL
  • writer_id (task작성자 id) — bigtint — Foreign key → USER.user_id — NOT NULL
  • manager_id (task 관리자 id) — bigtint — Foreign key → USER.user_id — NOT NULL
  • title (제목) — bigint
  • content (내용) — text
  • manager (담당자) — varchar(10) — NOT NULL
  • start_date (시작일자) — datetime
  • end_date (종료일자) — datetime
  • update (수정일자) — datetime — NOT NULL

TASK_AUTHORITY (task의 권한(모든구성원/리더만))

  • task_authority_id (Key) — bigint — Primary key — NOT NULL
  • task_id (PK) — bigint — Foreign key → TASK.task_id — NOT NULL
  • authority (권한) — varchar(20)

TASK_STATUS (task 상태(할 일, 진행중, 완료))

  • task_status_id (bigint) — bigint — Primary key — NOT NULL
  • status_id (PK) — bigint — Foreign key → STATUS.status_id — NOT NULL
  • task_id (PK2) — bigint — Foreign key → TASK.task_id — NOT NULL

TASK_TAG (task의 태그들)

  • task_tag_id (Key) — bigint — Primary key — NOT NULL
  • task_id (Key3) — bigint — Foreign key → TASK.task_id — NOT NULL
  • tag (해시태그) — varchar(15) — NOT NULL

USER (유저)

  • user_id (Key) — bigtint — Primary key — NOT NULL
  • mail (메일) — varchar(100) — NOT NULL
  • id (아이디) — varchar(20) — NOT NULL
  • password (비밀번호) — varchar(20) — NOT NULL
  • nickname (닉네임) — varchar(20) — NOT NULL
  • phone_number (전화번호) — varchar(20) — NOT NULL
  • is_online (접속 중 확인) — boolean — NOT NULL