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