owing

Tables (20)

CopyOfcharacter

  • id — LONG — Primary key — NOT NULL
  • image — VARCHAR
  • name — VARCHAR(255) — NOT NULL
  • gender — VARCHAR
  • birthdate — DATE
  • job — VARCHAR
  • appearance — VARCHAR — 외형
  • personality — VARCHAR — 성격
  • values — VARCHAR — 가치관
  • habits — VARCHAR — 습관
  • likes — VARCHAR — 좋아하는 것
  • dislikes — VARCHAR — 싫어한는 것
  • hobby — VARCHAR — 취미
  • family_relationship — VARCHAR(255) — NOT NULL — 가족관계
  • friend_relationship — VARCHAR(255) — NOT NULL — 친구관계
  • education — VARCHAR(255) — 학력
  • craving — VARCHAR(255) — 욕망
  • objective — VARCHAR(255) — 목표
  • etc — TEXT — 기타

cast

  • id — UUID — Primary key — NOT NULL
  • castfolder_id — UUID — Foreign key → cast_folder.id — NOT NULL
  • image_url — VARCHAR(2083)
  • name — VARCHAR(50) — NOT NULL
  • age — VARCHAR(50)
  • gender — VARCHAR(50)
  • role — VARCHAR(200) — 역할/직업
  • description — VARCHAR(1000) — 세부사항
  • coord — Coord — coord : { x: 0, y: 0 }

cast_folder

  • id — UUID — Primary key — NOT NULL
  • project_id — LONG — Foreign key → project.id — NOT NULL
  • name — VARCHAR(50)
  • description — VARCHAR(1000)
  • position — LONG — NOT NULL — 순서

character_chats

  • chat_id — INT
  • user_id — INT
  • character_id — INT
  • chat_message — TEXT
  • created_at — TIMESTAMP

collaborations

  • collaboration_id — INT
  • project_id — INT
  • collaborator_id — INT
  • role — VARCHAR(255)

member

  • id — LONG — Primary key — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20) — 개인 식별 수단
  • profile_url — VARCHAR(2083)
  • provider — VARCHAR(20) — NOT NULL
  • ai_point — LONG

member_setting

  • id — LONG — Primary key — NOT NULL
  • member_id — LONG — Foreign key → member.id — NOT NULL

notification

  • notification_id — INT
  • user_id — INT
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

objects

  • object_id — INT
  • user_id — INT
  • object_name — VARCHAR(255)
  • object_description — TEXT
  • created_at — TIMESTAMP

project

  • id — LONG — Primary key — NOT NULL
  • member_id — LONG — Foreign key → member.id — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • description — VARCHAR(1000) — NOT NULL
  • category — VARCHAR(20) — NOT NULL — "드라마". "웹소설", "영화" 등등
  • genre — VARCHAR — "로맨스", "스릴러", "액션" 등등
  • cover_url — VARCHAR(2083)
  • accessed_at — DATETIME

project_setting

  • id — LONG — Primary key — NOT NULL
  • project_id — LONG — Foreign key → project.id — NOT NULL
  • text_count_style — VARCHAR(50)
  • platform — VARCHAR(50)
  • script_style — VARCHAR(50)
  • font_size — SHORT
  • font_style — VARCHAR(50)

story

  • id — LONG — Primary key — NOT NULL
  • story_folder_id — LONG — Foreign key → story_folder.id — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • description — VARCHAR(1000)
  • text_count — INTEGER
  • position — LONG — NOT NULL — 순서

story_folder

  • id — LONG — Primary key — NOT NULL
  • project_id — LONG — Foreign key → project.id — NOT NULL
  • name — VARCHAR(50)
  • description — VARCHAR(1000)
  • position — LONG — NOT NULL — 순서

storyblock

  • id — LONG — Primary key — NOT NULL
  • storyplot_id — LONG — Foreign key → story.id — NOT NULL
  • content — TEXT
  • position — LONG

trashcan

  • id — LONG — Primary key — NOT NULL
  • project_id — LONG — Foreign key → project.id — NOT NULL
  • table_name — VARCHAR(50) — 삭제한 소요의 Table 명
  • item_id — VARCHAR(40) — 요소의 pk
  • item_title — VARCHAR(50) — 요소에 대한 표시(요소 이름 등)
  • created_at — DATETIME

universe

  • id — LONG — Primary key — NOT NULL
  • universe_folder_id — LONG — Foreign key → universe_folder.id — NOT NULL
  • name — VARCHAR(50)
  • description — TEXT
  • image_url — VARCHAR(2083) — 이미지
  • position — LONG — NOT NULL — 순서

universe_folder

  • id — LONG — Primary key — NOT NULL
  • project_id — LONG — Foreign key → project.id — NOT NULL
  • name — VARCHAR(50)
  • description — VARCHAR(1000)
  • position — LONG — NOT NULL — 순서

version

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • version_id — INT
  • story_id — INT
  • version_name — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP

writing_stats

  • id — LONG — Primary key — NOT NULL
  • member_id — LONG — Foreign key → member.id — NOT NULL
  • date — DATE
  • work_amount — INTEGER

ㅇㅇ

  • id — LONG — Primary key — NOT NULL
  • nation — VARCHAR(255) — 국가
  • city — VARCHAR(255) — 도시
  • village — VARCHAR(255) — 마을
  • space — VARCHAR(255) — 주거 공간
  • environment — VARCHAR(255) — 환경
  • historical_background — VARCHAR(255) — 시대 ( ex. 조선시대, 고려시대 )
  • national_system — VARCHAR(255) — 국가체제
  • hierarchy — VARCHAR(255) — 계급 제도
  • racial — VARCHAR(255) — 인종 구성
  • language — VARCHAR(255) — 언어
  • religion — VARCHAR(255) — 종교
  • art — VARCHAR(255) — 예술
  • etc — TEXT — 기타