creativalDB
Tables (29)
BOARD (Untitled11)
- ID — BIGINT — Primary key — NOT NULL
- title — varchar — NOT NULL
- boardText — text — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL — 작성자 아이디
- created_at — datetime — NOT NULL
- updated_at — datetime
- board_type — ENUM — NOT NULL — 창작자 전용 게시판 글인지 아니면 일반인지 creator, nomal
BOARD_file (CopyOfUntitled4)
- ID (Key) — BIGINT — Primary key — NOT NULL
- file_url — varchar(500) — NOT NULL
- file_name — varchar — NOT NULL — 파일 원본 이름이 저장됨
- board_id — BIGINT — Foreign key → BOARD.ID — NOT NULL
- file_original_name — NOT NULL
Episode (Untitled6)
- ID (Key) — BIGINT — Primary key — NOT NULL
- series_id (Key2) — BIGINT — Foreign key → Series.ID — NOT NULL
- episode_num — int — NOT NULL — 몇 화인지 표시 아마 자동 숫자 부여일듯
- title — varchar — NOT NULL
- Novel_content — text — 소설일 경우에만 내용을 집어넣어야함
- is_free — boolean — 무료인지 확인용
- note — TEXT
- created_at — datetime
- updated_at — datetime
- isDeleted — boolean — NOT NULL
- view_count — BIGINT — NOT NULL
Folder (Untitled21)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- name (folder_name) — varchar — NOT NULL
- is_default — boolean — NOT NULL — 기본으로 제공되는 것인지 ex) 구독 폴더, 구매 폴더
- sort_order — int — NOT NULL — 순서
Folder_item (Untitled22)
- folder_id — BIGINT — Foreign key → Folder.ID — NOT NULL
- content_id — BIGINT — Foreign key → content.ID — NOT NULL
- sort_order — int — NOT NULL — 폴더 내 정렬 순서
- is_pinned — boolean — 상단 고정 여부
- created_at — datetime — NOT NULL — 보관함에 담은 시간
Follow (Untitled14)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- following_id (following_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- following_id (following_user_id) — BIGINT — Foreign key → User.ID — NOT NULL
- following_type — varchar — NOT NULL — team인지 user인지
- created_at — datetime — NOT NULL — 팔로우한 날짜
Order_log (Untitled19)
- ID — BIGINT — Primary key — NOT NULL
- user_id (Key) — BIGINT — Foreign key → User.ID — NOT NULL — 구매자
- item_type — varchar — NOT NULL — sale(단품),sub(구독)
- item_id (item_sale_id) — BIGINT — Foreign key → sale_item.ID — NOT NULL
- item_id (item_sub_id) — BIGINT — Foreign key → Subscription_list.ID — NOT NULL
- order_type — ENUM — NOT NULL — 결제 유형 NEW, RENEWAL
- amount — DECIMAL — NOT NULL — 실제 결재 금액
- status — ENUM — NOT NULL — 결재의 결과 COMPLETED, FAILED, REFUNDED
- created_at — datetime — NOT NULL — 결제 일시
Permission (Untitled15)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- target_id (target_project_id) — BIGINT — Foreign key → project.ID — NOT NULL
- target_id (target_episode_id) — BIGINT — Foreign key → Episode.ID — NOT NULL
- target_type — varchar — NOT NULL — content, projectm,team,episode 등으로 나눠서 권한을 관리함
- source_type — ENUM — NOT NULL — 구매인지 후원인지 BUY or SUB or Redeem code
- expired_at — datetime — NOT NULL — 권한 만료일 NULL일 경우에는 영구임
- sub_list_id — BIGINT — Foreign key → Subscription_list.ID — NOT NULL
Redeem_code (Untitled20)
- ID — BIGINT — Primary key — NOT NULL
- creator_id — BIGINT — Foreign key → User.ID — NOT NULL — 키 생성자 보통 팀 프로젝트는 팀장 그리고 개인 창작물은 본인
- Redeem_code — VARCHAR — NOT NULL — 유니크한 난수
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_project_id) — BIGINT — Foreign key → project.ID — NOT NULL
- target_id (target_sub_list_id) — BIGINT — Foreign key → Subscription_list.ID — NOT NULL
- target_id (target_episode_id) — BIGINT — Foreign key → Episode.ID — NOT NULL
- target_type — varchar — NOT NULL — content, project, sub_list, episode
- duration_days — int — 유효기간(일) 구독형 또는 대여형이 아니라면 null
- is_used — boolean — NOT NULL — 사용 여부
- user_id — BIGINT — Foreign key → User.ID — 사용한 유저의 아이디
- used_at — datetime — 사용된 날짜
- expired_at — datetime — 코드의 만료일 아마 유저가 설정하는 방식이 아닐까
Series (Untitled5)
- ID (Key) — BIGINT — Primary key — NOT NULL
- cotent_id (Key2) — BIGINT — Foreign key → content.ID — NOT NULL
- is_end — boolean — NOT NULL — 시리즈 완결 여부
- total_episode — int — NOT NULL — 총 화 수
Subscription (Untitled17)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- sub_list_id — BIGINT — Foreign key → Subscription_list.ID — NOT NULL
- status — ENUM — NOT NULL — ACTIVE, CANCELED, EXPIRED
- next_billing_date — datetime — 다음 결재일
- created_at — datetime — NOT NULL — 언제 생성되었는지
Subscription_list (Untitled16)
- ID — BIGINT — Primary key — NOT NULL
- owner_type — varchar — NOT NULL — user, team
- onwer_id (onwer_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- owner_id (owner_user_id) — BIGINT — Foreign key → User.ID — NOT NULL
- user_id (creator user_id) — BIGINT — Foreign key → User.ID — 생성자, 소유자
- name (Field) — varchar — NOT NULL
- price — DECIMAL — NOT NULL — 가격
- description — TEXT — 설명
Tag (Untitled7)
- ID — BIGINT — Primary key — NOT NULL — 태그 아이디
- tag_text — varchar — NOT NULL — 표시되는 태그 명
- created_at — datetime — NOT NULL — 만들어진 날짜
- creator_id — BIGINT — Foreign key → User.ID — NOT NULL
Tag_Team_Mapping (CopyOfUntitled82)
- ID — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.ID — NOT NULL — 태그 아이디
- team_id — BIGINT — Foreign key → team.ID — NOT NULL
- created_at — datetime — NOT NULL
Tag_User_Mapping (Untitled8)
- ID — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.ID — NOT NULL — 태그 아이디
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- created_at — datetime — NOT NULL
Tag_content_Mapping (CopyOfUntitled8)
- ID — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.ID — NOT NULL — 태그 아이디
- content_id — BIGINT — Foreign key → content.ID — NOT NULL
- created_at — datetime — NOT NULL
Tag_project_Mapping (CopyOfCopyOfUntitled82)
- ID — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.ID — NOT NULL — 태그 아이디
- project_id — BIGINT — Foreign key → project.ID — NOT NULL
- created_at — datetime — NOT NULL
User (user table)
- ID (Key) — BIGINT — Primary key — NOT NULL
- username — varchar(50) — NOT NULL — UNIQUE
- email (user email) — varchar(320) — NOT NULL — UNIQUE
- password (user password) — varchar(255) — NOT NULL
- display_name (user display name or nickname) — varchar(255) — NOT NULL
- profile_img (profile img url) — varchar(500)
- description — TEXT
- role (user role) — ENUM(ADMIN,USER) — NOT NULL
- created_at (user created date) — datetime — NOT NULL
- is_creator (user is creator?) — boolean — NOT NULL
- is_Verification — boolean — NOT NULL — is_creator이 Y일 경우 인증된지를 판단하는 것
- isDeleted — boolean
- deleted_at — datetime
bookmark (Untitled10)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- target_type — varchar — NOT NULL — content or team
- target_id (target_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_user_id) — BIGINT — Foreign key → User.ID — NOT NULL
- created_at — datetime — NOT NULL
checkout (Untitled12)
- ID — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.ID — NOT NULL
- is_checked — boolean — NOT NULL — 체크됐는지 안 됐는지
- sort_order — int — NOT NULL — 몇 번째인지
- deadline — datetime
- checked_at — datetime — 체크된 날
comment (Untitled9)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL — 작성자 아이디
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- target_id (target_board_id) — BIGINT — Foreign key → BOARD.ID — NOT NULL
- target_id (target_episode_id) — BIGINT — Foreign key → Episode.ID — NOT NULL
- target_type — varchar — NOT NULL — 나중에 구현할 때 이게 어떤 유형인지를 결정합니다.
- content (comment content) — varchar — NOT NULL — 댓글 내용
- parent_id — BIGINT — 부모가 있을 경우 ID를 추가함
- created_at — datetime — NOT NULL
- updated_at — datetime — 수정 날짜
content (Untitled3)
- ID (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- team_id — BIGINT — Foreign key → team.ID — 팀이 있을 경우에만
- project_id — BIGINT — Foreign key → project.ID
- owner_type (owner type) — ENUM — NOT NULL — 콘텐츠 소유자의 유형을 묻는겁니다.
- type — varchar — NOT NULL — 어떤 유형의 창작물인지 넣기 필수
- title — varchar — NOT NULL
- Thumbnail_img_url (Thumbnail img url) — varchar(500) — Thumbnail은 썸네일을 뜻함
- visibility — ENUM — NOT NULL — 볼 수 있는 권한을 의미함
- is_allow_comment (is allow comment) — boolean — NOT NULL — 댓글을 허용하는지 안 하는지 여부
- view_count — BIGINT — NOT NULL — 조회수
- created_at — datetime — NOT NULL — 생성 날짜
- updated_at — datetime — 수정 날짜
- is_Fan_work (Field) — boolean — NOT NULL — 이게 2차 창작인지 아닌지
- original_content_id — BIGINT — 2차 창작이라면 원본 ID
- description — TEXT
content_file (Untitled4)
- ID (Key) — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Foreign key → content.ID
- file_type — varchar — 확장자 넣으라는 거임
- file_url — varchar(500)
- sort_order — int — NOT NULL — 들어간 순서
- file_name — UUID — NOT NULL — 파일 원본 이름이 저장됨
- Episode_id — BIGINT — Foreign key → Episode.ID
- file_original_name — varchar — NOT NULL
like (Untitled13)
- user_id — BIGINT — Foreign key → User.ID — NOT NULL
- target_id (target_comment_id) — BIGINT — Foreign key → comment.ID — NOT NULL
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_team_id) — BIGINT — Foreign key → team.ID — NOT NULL
- target_id (target_project_id) — BIGINT — Foreign key → project.ID — NOT NULL
- target_id (target_episode_id) — BIGINT — Foreign key → Episode.ID — NOT NULL
- target_type — varchar — NOT NULL — 어디 좋아요인지
- created_at — datetime — NOT NULL
project (Untitled2)
- ID (Key) — BIGINT — Primary key — NOT NULL
- title — varchar — NOT NULL
- description — TEXT
- status — ENUM — NOT NULL — 프로젝트의 상태
- total_progress (total progress) — int — NOT NULL — 0~100%
- start_date — datetime — NOT NULL — 시작일
- end_date — datetime — 마감일 혹은 종료일
- team_id — BIGINT — Foreign key → team.ID — NOT NULL
- visibility — ENUM — NOT NULL — PULBIC PROTECTED PRIVATE 등으로 나뉨
- bannerImgUrl — varchar(500)
sale_item (Untitled18)
- ID — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL — 생성자, 판매자
- target_id (target_content_id) — BIGINT — Foreign key → content.ID — NOT NULL
- target_id (target_project_id) — BIGINT — Foreign key → project.ID — NOT NULL
- target_id (target_episode_id) — BIGINT — Foreign key → Episode.ID — NOT NULL
- target_type — varchar — NOT NULL — content, episode, project
- price — DECIMAL — NOT NULL — 0원이면 무료
- owner_id (owner_user_id) — BIGINT — Foreign key → User.ID — NOT NULL — 소유자, 수익 받는 사람
- owner_id — BIGINT — Foreign key → team.ID — NOT NULL — 소유자, 수익 받는 사람
- owner_type — varchar — NOT NULL
- sale_status — ENUM — NOT NULL — ON_SALE, STOP, HIDDEN
- is_permanent — boolean — NOT NULL — 빌리는 거면 N인거임
team (team table)
- ID (Key) — BIGINT — Primary key — NOT NULL
- user_id (Leader__id) — BIGINT — Foreign key → User.ID — NOT NULL
- name (team name) — varchar — NOT NULL — 팀명은 중복하면 안 됨
- description — TEXT
- profile_img (profile img url) — varchar(500)
- banner_img (banner img url) — varchar(500) — NOT NULL
- status — varchar — NOT NULL — 팀의 현 상태(활동, 휴식)
- created_at (created date) — datetime — NOT NULL — 생성일
- updatedAt — datetime
- visibility — ENUM — NOT NULL
team_member (Untitled)
- team_id (Key) — BIGINT — Foreign key → team.ID — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.ID — NOT NULL
- role (team role) — ENUM(leader,member) — NOT NULL — 팀의 유저 권한
- position — varchar(50) — NOT NULL
- joined_at — datetime — NOT NULL — 참여일
user_token (Untitled23)
- ID — BIGINT — Primary key — NOT NULL
- token — UUID — NOT NULL
- user_id — BIGINT — Foreign key → User.ID — NOT NULL