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