헤이영
테이블 (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