dan-mu-zi

Tables (13)

Untitled (member)

  • Key (member_id) — BIGINT — Primary key — NOT NULL
  • Field (authId) — Long
  • Field (name) — String — NOT NULL
  • Field (member_image_url) — String
  • Field (email) — String
  • Field (isFaceCaptured) — BOOL — NOT NULL
  • Field2 (onlyWifi) — BOOL — NOT NULL
  • Field (access_token) — String — NOT NULL
  • Field (refresh_token) — String — NOT NULL
  • Field (createdAt) — DATETIME
  • Field (updatedAt) — DATETIME
  • Field (deletedAt) — DATETIME
  • Field (loginId) — String
  • Field (loginPassword) — String

Untitled (member_sample_image)

  • Key (member_sample_image_id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (angleType) — ENUM — NOT NULL
  • Field (faceVector) — String
  • Field (createdAt) — DATETIME
  • Field (updatedAt) — DATETIME
  • Field (deletedAt) — DATETIME

Untitled (shareGroup)

  • Key (sharegroup_id) — BIGINT — Primary key — NOT NULL
  • Field (progress_percent) — ENUM — NOT NULL
  • Field (group_color) — String
  • Field (group_image_url)
  • Field (group_name) — String — NOT NULL
  • Field (description) — String — NOT NULL
  • Field (place) — String — NOT NULL
  • Field (started_at) — DATETIME — NOT NULL
  • Field (ended_at) — DATETIME — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME
  • Field (deleted_at) — DATETIME

Untitled (profile)

  • Key (profile_id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (sharegroup_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — ENUM — NOT NULL
  • Field (joinedAt) — DATETIME

Untitled (photo)

  • Key (photo_id) — BIGINT — Primary key — NOT NULL
  • Field (photo_url) — String — NOT NULL
  • Field (location) — String — NOT NULL
  • Field (take_at) — DATETIME — NOT NULL
  • Field (uploader_profile_id) — BIGINT — NOT NULL
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • Field (deleted_at) — DATETIME

Untitled (photo_like)

  • Key (photo_like_id) — BIGINT — Primary key — NOT NULL
  • Key (profile_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (photo_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (photo_download_log)

  • Key (photo_download_log_id) — BIGINT — Primary key — NOT NULL
  • Key (profile_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (photo_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (photo_profile_map)

  • Key (photo_profile_map_id) — BIGINT — Primary key — NOT NULL
  • Key (photo_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (profile_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (notification)

  • Key (notification_id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (message) — String — NOT NULL
  • Field (is_checked) — Boolean — NOT NULL
  • Field (createdAt) — DATETIME — NOT NULL
  • Field (deletedAt) — DATETIME

Untitled (device_token)

  • Key (device_token_id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (fcm_token) — String — NOT NULL
  • Field (createdAt) — DATETIME
  • Field (updatedAt) — DATETIME
  • Field (deletedAt) — DATETIME

Untitled (photo_upload_notification)

  • Key (notification_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (photo_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (trip_start_notification)

  • Key (notification_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (sharegroup_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (trip_start_date) — DATETIME — NOT NULL

Untitled (shareGroup_join_notification)

  • Key (notification_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (profile_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL