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