GYMMI

Tables (21)

favoirte_mission (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • worker_id (Key3) — bigint — Foreign key → worker.id — NOT NULL — unique(2)
  • mission_id (Key2) — bigint — Foreign key → mission.id — NOT NULL — unique(2)
  • c_m_at (Field) — NOT NULL

fcm_token (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL
  • token (Field)
  • timestamp (Field2) — NOT NULL
  • c_m_at (Field3) — NOT NULL

feedback (Untitled2)

  • id (Key2) — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL
  • content (Field) — tinytext — NOT NULL
  • c_m_at (Field2) — NOT NULL

logined (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL
  • refresh_token (Field) — NOT NULL
  • c_m_at (Field2) — NOT NULL

mission (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • workspace_id (Key2) — bigint — Foreign key → workspace.id — NOT NULL
  • name (Field) — varchar(20) — NOT NULL
  • score (Field2) — int — NOT NULL

notification (Untitled19)

  • id (Key) — Primary key — NOT NULL
  • type_id (Key2) — Foreign key → notification_type.id — NOT NULL
  • target_id (Field4)
  • failed (Field) — NOT NULL
  • title (Field3) — NOT NULL
  • body (Field2) — NOT NULL
  • published_at (Field5) — NOT NULL
  • c_m_at (Field6) — NOT NULL

notification_type (Untitled18)

  • id (Key) — Primary key — NOT NULL
  • type (Field) — NOT NULL
  • redirect_url (Field2) — NOT NULL
  • title (Field4)
  • body (Field3) — NOT NULL

objection (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • worker_id (Key3) — bigint — Foreign key → worker.id — NOT NULL
  • workout_confirmation_id (Key2) — Foreign key → workout_confirmation.id — NOT NULL — unique
  • reason (Field2)
  • is_in_progress (Field)
  • c_m_at (Field3)

photo_feed (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL
  • comment (Field2) — NOT NULL
  • is_modified (Field3) — NOT NULL
  • c_m_at (Field) — NOT NULL
  • Field4

photo_feed_image (Untitled15)

  • id (Key) — Primary key — NOT NULL
  • photo_feed_id (Key2) — Foreign key → photo_feed.id — NOT NULL — unique
  • filename (Field) — NOT NULL

profile_image (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL
  • stored_name (Field) — varchar(255) — NOT NULL
  • origin_name (Field2) — varchar(255) — NOT NULL
  • c_m_at (Field3) — NOT NULL

thumbs_up (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL — unique(2)
  • photo_feed_id (Key2) — Foreign key → photo_feed.id — NOT NULL — unique(2)
  • c_m_at (Field2) — NOT NULL

uuser (사용자)

  • id — bigint — Primary key — NOT NULL
  • login_id (Field) — varchar(12) — NOT NULL
  • password (Field2) — NOT NULL
  • nickname (Field3) — varchar(5) — NOT NULL
  • email (Field4)
  • is_resigned (Field5) — NOT NULL
  • c_m_at (Field6) — NOT NULL

vote (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • worker_id (Key3) — bigint — Foreign key → worker.id — NOT NULL — unique(2)
  • objection_id (Key2) — bigint — Foreign key → objection.id — NOT NULL — unique(2)
  • is_approved (Field) — boolean — NOT NULL
  • automatic (Field3) — NOT NULL
  • c_m_at (Field2) — NOT NULL

worker (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (2) — bigint — Foreign key → uuser.id — NOT NULL — unique(2)
  • workspace_id (Key2) — bigint — Foreign key → workspace.id — NOT NULL — unique(2)
  • contributed_score (Field) — bigint — NOT NULL — 삭제하기?
  • c_m_at (Field2) — NOT NULL

workout_confirmation (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • filename (Field) — NOT NULL
  • comment (Field2) — NOT NULL

workout_history (CopyOfUntitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • woker_id (Key2) — bigint — Foreign key → worker.id — NOT NULL
  • workout_confirmation_id (Key3) — Foreign key → workout_confirmation.id — NOT NULL — unique
  • total_score (Field3) — NOT NULL
  • is_approved (Field) — boolean — NOT NULL
  • c_m_at (Field2) — timestamp(3) — NOT NULL

workout_record (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • workout_history_id (Key2) — bigint — Foreign key → workout_history.id — NOT NULL
  • mission_id (Key3) — bigint — Foreign key → mission.id — NOT NULL
  • count (Field) — int — NOT NULL

workspace (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • creator (2) — bigint — Foreign key → uuser.id — NOT NULL
  • name (Field) — varchar(9) — NOT NULL
  • password (Field5) — varchar(4) — NOT NULL
  • status (Field6) — NOT NULL
  • description (Field8)
  • goal_score (Field3) — bigint — NOT NULL
  • head_count (Field7) — int — NOT NULL
  • c_m_at (Field2) — NOT NULL
  • tag (Field4) — varchar(10)

workspace_result (Untitled17)

  • id (Key) — Primary key — NOT NULL
  • workspace_id (Key2) — bigint — Foreign key → workspace.id — NOT NULL
  • winner_id (Key3) — bigint — Foreign key → worker.id — NOT NULL
  • loser_id (Key4) — bigint — Foreign key → worker.id — NOT NULL
  • c_m_at (Field) — bigint — NOT NULL

사진 커뮤니티 (Untitled9)

  • Key — Primary key — NOT NULL
  • 유저id (Field)
  • 이미지 url (Field2)
  • 코멘트 (Field3)