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