헤이영

테이블 (12)

AccountTransaction

  • transaction_id — INT
  • account_id — INT
  • user_id — INT
  • amount — DECIMAL(10, 2) — NOT NULL
  • transaction_date — TIMESTAMP
  • description — TEXT

Event

  • event_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • event_type — ENUM('personal', 'meeting', 'lecture', 'academic') — NOT NULL
  • created_by — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

EventFeedback

  • feedback_id — INT
  • event_id — INT
  • user_id — INT
  • feedback_type — ENUM('verification', 'comment', 'issue') — NOT NULL
  • created_at — TIMESTAMP

EventReminder

  • reminder_id — INT
  • event_id — INT
  • user_id — INT
  • reminder_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

Finance

  • finance_id — INT
  • user_id — INT
  • amount — DECIMAL(10, 2) — NOT NULL
  • transaction_type — ENUM('deposit', 'withdrawal') — NOT NULL
  • transaction_date — TIMESTAMP
  • description — TEXT

Incentive

  • incentive_id — INT
  • user_id — INT
  • amount — DECIMAL(10, 2) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

Lecture

  • lecture_id — INT
  • name — VARCHAR(255) — NOT NULL
  • professor_name — VARCHAR(255)
  • course_code — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Meeting

  • meeting_id — INT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • creator_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

SharedAccount

  • account_id — INT
  • account_name — VARCHAR(255) — NOT NULL
  • created_by — INT
  • created_at — TIMESTAMP

User

  • user_id — INT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • role — ENUM('student', 'admin') — NOT NULL
  • student_id — VARCHAR(50)
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

UserLecture

  • user_id — INT
  • lecture_id — INT
  • enrolled_at — TIMESTAMP

UserMeeting

  • user_id — INT
  • meeting_id — INT
  • joined_at — TIMESTAMP