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 — 기타