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)