moatoon_db_init
Tables (9)
author (작가)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(30)
contents (콘텐츠)
- id (Key) — int — Primary key — NOT NULL
- platformId (Key2) — int — Foreign key → platform.id — NOT NULL
- genreId (Key3) — int — Foreign key → genre.id — NOT NULL
- uuid (Field8) — binary(16)
- day (Field2) — varchar(3), ex) mon, tue, wed, thu, fri, sat, sun
- ageLimit (Field7) — int
- title (Field3) — varchar(100)
- description (Field4) — text
- postedAt (Field5) — datetime
- endedAt (Field6) — datetime
contentsAuthor (콘텐츠 작가)
- contentsId (Key2) — int — Foreign key → contents.id — NOT NULL
- authorId (Key3) — int — Foreign key → author.id — NOT NULL
episodeThumbnail (에피소드 썸네일)
- id (Key) — int — Primary key — NOT NULL
- episodeId (Key2) — int — Foreign key → episodes.id — NOT NULL
- contentsId (Key3) — int — Foreign key → episodes.contentsId — NOT NULL
- filename (Field2) — varchar(100)
- uploadPath (Field3) — varchar(100)
- uploadedPath (Field4) — datetime
episodes (에피소드)
- id (Key) — int — Primary key — NOT NULL
- contentsId (Key2) — int — Foreign key → contents.id — NOT NULL
genre (장르)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(30)
- parentId (Field2) — int
platform (플랫폼)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(30)
ratings (평점)
- id (Key) — int — Primary key — NOT NULL
- contentsId (Key2) — int — Foreign key → contents.id — NOT NULL
- userId (Field3) — int
- value (Field2) — tinyint
thumbnailImage (썸네일 이미지)
- id (Key) — int — Primary key — NOT NULL
- contentsId (Key2) — int — Foreign key → contents.id — NOT NULL
- filename (Field) — varchar(100)
- uploadPath (Field2) — varchar(100)
- uploadedAt (Field4) — datetime