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