seminar7
Tables (6)
Crew (크루)
- crew_id (크루번호) — int — Primary key — NOT NULL
- crewname (크루명) — varchar(100)
- crew_code (초대코드) — varchar(10)
- date (크루 생성일) — datetime
Crew_Goal (크루 목표)
- goal_id (목표번호) — int — Primary key — NOT NULL
- crew_id (크루번호) — int — Foreign key → Crew.crew_id — NOT NULL
- goal_type (목표 종류) — enum
- target_value (목표치) — int
- current_value (현재 달성치) — int
- is_achieved (달성여부) — boolean
- deadline (목표기한) — datetime
Crew_Member (크루멤버)
- crew_mem_id (크루멤버 번호) — Primary key — NOT NULL
- user_id (유저번호) — int — Foreign key → User.user_id — NOT NULL
- crew_id (크루번호) — int — Foreign key → Crew.crew_id — NOT NULL
- role (역할) — enum
- joindate (참여일) — datetime
Donation (기부)
- donation_id (기부 고유 번호) — int — Primary key — NOT NULL
- goal_id (목표번호) — int — Foreign key → Crew_Goal.goal_id — NOT NULL
- crew_id (크루번호) — int — Foreign key → Crew.crew_id — NOT NULL
- amount (기부액) — int
- charity_name (기부처) — varchar(100)
- donate_date (기부일) — datetime
User (유저)
- user_id (유저번호) — int — Primary key — NOT NULL
- username (이름) — varchar(100) — NOT NULL
- password (비밀번호) — varchar(100) — NOT NULL
- email (이메일) — varhar(100) — NOT NULL
Workout_Log (운동기록)
- workout_id (운동고유번호) — int — Primary key — NOT NULL
- user_id (유저번호) — int — Foreign key → User.user_id — NOT NULL
- workout_type (운동종류) — enum
- value (운동량) — int
- calories (칼로리 소모량) — int
- workout_date (운동일시) — datetime