timetile

Tables (15)

Artist (artists)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • imageUrl (Field2) — char

ArtistGenre (artists_genres)

  • id (Key) — bigint — Primary key — NOT NULL
  • artistId (Key2) — bigint — Foreign key → Artist.id — NOT NULL
  • genreId (Key3) — bigint — Foreign key → Genre.id — NOT NULL

Comment (comments)

  • id (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.id — NOT NULL
  • content (Field) — varchar
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime

CommentLike (comment_likes)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → User.id — NOT NULL
  • commentId (Key3) — bigint — Foreign key → Comment.id — NOT NULL

Edit (edits)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → User.id — NOT NULL
  • scheduleId (Key3) — bigint — Foreign key → Tile.id — NOT NULL
  • updatedAt (Field) — datetime

Folder (folders)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → User.id — NOT NULL
  • name (Field) — varchar

FolderPost (folders_posts)

  • id (Key) — bigint — Primary key — NOT NULL
  • folderId (Key2) — bigint — Foreign key → Folder.id — NOT NULL
  • postId (Key3) — bigint — Foreign key → Post.id — NOT NULL

Follow (follows)

  • id (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → User.id — NOT NULL
  • artistId (Key3) — bigint — Foreign key → Artist.id — NOT NULL

Genre (genres)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(15)
  • imageUrl (Field2) — char

Post (posts)

  • id (Key) — bigint — Primary key — NOT NULL
  • scheduleId (Key2) — bigint — Foreign key → Tile.id — NOT NULL
  • userId (Key3) — bigint — Foreign key → User.id — NOT NULL
  • title (Field) — varchar(50)
  • content (Field2) — varchar(500)
  • createdAt (Field3) — datetime
  • updatedAt (Field4) — datetime
  • scheduledAt (Field5) — datetime
  • visibility (Field6) — char

PostImage (post_images)

  • id (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.id — NOT NULL
  • Field

PostLike (post_likes)

  • Key — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → User.id — NOT NULL
  • postId (Key3) — bigint — Foreign key → Post.id — NOT NULL

ScheduleImage (schedule_images)

  • id (Key) — bigint — Primary key — NOT NULL
  • scheduleId (Key2) — bigint — Foreign key → Tile.id — NOT NULL
  • imageUrl (Field) — char

Tile (tiles)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • scheduledAt (Field2) — datetime
  • description (Field3) — varchar(500)
  • status (Field4) — char

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • nickname (Field) — varchar(15)
  • imageUrl (Field2) — char
  • grade (Field3) — char
  • indroduction (Field4) — varchar(20)