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