Recorday
Tables (4)
fourcut
- fourcutId (fourcut_id) — bigint(20) — Primary key — NOT NULL
- userId (user_id) — bigint(20) — Foreign key → user.userId — NOT NULL
- frameId (frame_id) — bigint(20) — Foreign key → frame.frameId — NOT NULL
- photoUrl (photo_url) — varchar(1024) — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp — NOT NULL
- videoUrl (video_url) — varchar(1024) — NOT NULL
frame
- frameId (frame_id) — bigint(20) — Primary key — NOT NULL
- userId (user_id) — bigint(20) — Foreign key → user.userId — NOT NULL
- publicId (public_id) — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
- source — varchar(1024) — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp — NOT NULL
frame_component
- frameComponentId (frame_component_id) — bigint(20) — Primary key — NOT NULL
- frameId (frame_id) — bigint(20) — Foreign key → frame.frameId — NOT NULL
- publicId (public_id) — varchar(255) — NOT NULL
- source — varchar(1024) — NOT NULL
- backgroundAttributes (Field) — json — NOT NULL
user (users)
- userId (user_id) — bigint(20) — Primary key — NOT NULL
- publicId (public_id) — varchar(255) — NOT NULL
- provider — enum ('KAKAO', 'NAVER', 'RECORDAY') — NOT NULL
- providerId (provider_id) — varchar(64)
- userRole (user_role) — enum ('ROLE_ADMIN', 'ROLE_USER') — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255)
- username — varchar(255) — NOT NULL
- profileUrl (profile_url) — varchar(1024) — NOT NULL
- createdAt (created_at) — timestamp — NOT NULL
- updatedAt (updated_at) — timestamp — NOT NULL
- userStatus (user_status) — enum ('ACTIVE', 'DELETED', 'DELETED_REQUESTED', 'SUSPENDED') — NOT NULL
- deleteRequestedAt (delete_requested_at) — timestamp