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)