객소공

테이블 (4)

직원 (EMPLOYEE)

  • employee_id — VARCHAR(20) — 기본 키 — NOT NULL
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • position — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

학습동아리 (STUDY_CLUB)

  • study_club_id — INT — 기본 키 — NOT NULL
  • club_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • manager_id — VARCHAR(20) — NOT NULL
  • max_members — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

학습동아리 구성원 (STUDY_CLUB_MEMBER)

  • member_id — INT — 기본 키 — NOT NULL
  • study_club_id — INT — 외래 키 → 학습동아리.study_club_id — NOT NULL
  • employee_id — VARCHAR(20) — 외래 키 → 직원.employee_id — NOT NULL
  • join_date — DATE — NOT NULL
  • is_active — BOOLEAN
  • role — ENUM('MEMBER', 'MODERATOR')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

학습동아리 운영자 (STUDY_CLUB_MANAGER)

  • manager_id — INT — 기본 키 — NOT NULL
  • study_club_id — INT — 외래 키 → 학습동아리.study_club_id — NOT NULL
  • employee_id — VARCHAR(20) — 외래 키 → 직원.employee_id — NOT NULL
  • appointed_date — DATE — NOT NULL
  • is_active — BOOLEAN
  • manager_level — ENUM('MANAGER', 'ADMIN')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP