To-Go ERD
Tables (14)
community_comment
- id — INT
- feed_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
community_feed
- id — INT
- user_id — INT — NOT NULL
- crew_id — INT
- title — TEXT
- content — TEXT — NOT NULL
- view_count — INT
- created_at — TIMESTAMP — NOT NULL
community_like
- id — INT
- feed_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
crew_crew
- id — INT
- crew_name — VARCHAR(255) — NOT NULL
- crew_description — TEXT
- member_count — INT
- crew_image — VARCHAR(2048)
crew_crewmembership
- id — INT
- user_id — INT — NOT NULL
- crew_id — INT — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
retrospect_challenge
- id — INT
- user_id — INT
- crew_id — INT
- challenge_name — VARCHAR(255) — NOT NULL
- description — TEXT
- deadline — TIMESTAMP — NOT NULL
- owner_type — VARCHAR(10) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
retrospect_kpi
- id — INT
- challenge_id — INT — NOT NULL
- user_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- definition — TEXT
- measurement_unit — VARCHAR(50)
- data_type — VARCHAR(10) — NOT NULL
- measurement_method — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
retrospect_kpiresult
- id — INT
- user_id — INT — NOT NULL
- challenge_id — INT — NOT NULL
- kpi_id — INT — NOT NULL
- retrospect_id — INT — NOT NULL
- score — FLOAT — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP — NOT NULL
retrospect_plan
- id — INT
- user_id — INT
- challenge_id — INT
- plan_text — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
retrospect_retrospect
- id — INT
- plan_id — INT
- challenge_id — INT — NOT NULL
- template_id — INT
- user_id — INT — NOT NULL
- crew_id — INT
- content — JSON — NOT NULL
- visibility — VARCHAR(10) — NOT NULL
- owner_type — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
retrospect_retrospectweeklyanalysis
- id — INT
- user_id — INT
- crew_id — INT
- challenge_id — INT
- summary — TEXT
- comment — TEXT — EX
- assessment — TEXT
- avg_score — FLOAT
- min_score — FLOAT
- max_score — FLOAT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- owner_type — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
retrospect_template
- id — INT
- user_id — INT
- crew_id — INT
- owner_type — VARCHAR(10) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- steps — JSON — NOT NULL
- description — TEXT
- hashtag — JSON
retrospect_userchallngestatus
- id — INT
- user_id — INT — NOT NULL
- challenge_id — INT — NOT NULL
- status — VARCHAR(10) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_manager_user
- id — INT
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL