Making a database

[azadmuhammady2019-commits]

🏷️ Discussion Type

Bug

Body

-- ۱. ایجاد دیتابیس جدید آموزشگاه آماج
CREATE DATABASE IF NOT EXISTS amaj_db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci;
USE amaj_db;

---

-- ۲. جدول کاربران سیستم (ادمین‌ها، مدیران، کاربران پنل)
CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL, -- ذخیره به صورت Hash شده (مانند bcrypt)
full_name VARCHAR(100) NOT NULL,
role ENUM('admin', 'manager', 'staff') DEFAULT 'staff',
status ENUM('active', 'inactive') DEFAULT 'active',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۳. جدول اساتید آموزشگاه
CREATE TABLE IF NOT EXISTS teachers (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
father_name VARCHAR(100) DEFAULT NULL,
phone VARCHAR(15) DEFAULT NULL,
email VARCHAR(100) DEFAULT NULL,
specialty VARCHAR(100) NOT NULL, -- بخش تدریس مثل کمپیوتر، انگلیسی
salary DECIMAL(10, 2) NOT NULL DEFAULT 0.00, -- معاش ماهوار به افغانی
contract_date DATE DEFAULT NULL,
status ENUM('active', 'inactive') DEFAULT 'active',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۴. جدول کورس‌ها / صنف‌های آموزشی
CREATE TABLE IF NOT EXISTS courses (
id INT AUTO_INCREMENT PRIMARY KEY,
course_name VARCHAR(100) NOT NULL, -- مثل انگلیسی مبتدی، ریاضیات
teacher_id INT,
start_time TIME DEFAULT NULL,
end_time TIME DEFAULT NULL,
room_number VARCHAR(20) DEFAULT NULL,
status ENUM('active', 'completed', 'canceled') DEFAULT 'active',
FOREIGN KEY (teacher_id) REFERENCES teachers(id) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۵. جدول شاگردان (👨‍🎓 شاگردان)
CREATE TABLE IF NOT EXISTS students (
id VARCHAR(20) PRIMARY KEY, -- آیدی اختصاصی مثل AMJ-12345
name VARCHAR(100) NOT NULL,
father_name VARCHAR(100) NOT NULL,
phone VARCHAR(15) DEFAULT NULL,
registration_date DATE NOT NULL,
status ENUM('active', 'inactive', 'graduated') DEFAULT 'active',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۶. جدول ثبت‌نام شاگردان در صنف‌ها و وضعیت فیس
CREATE TABLE IF NOT EXISTS enrollments (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id VARCHAR(20) NOT NULL,
course_id INT NOT NULL,
fee_amount DECIMAL(10, 2) NOT NULL, -- مبلغ فیس تعیین شده برای این شاگرد
enroll_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۷. جدول حاضری شاگردان (📝 حاضری)
CREATE TABLE IF NOT EXISTS attendance (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id VARCHAR(20) NOT NULL,
course_id INT NOT NULL,
attendance_date DATE NOT NULL,
status ENUM('present', 'absent', 'sick', 'leave') NOT NULL,
marked_by INT, -- کاربری که حاضری را گرفته
FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (marked_by) REFERENCES users(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۸. جدول حسابداری و تراکنش‌های مالی (💰 حسابداری)
CREATE TABLE IF NOT EXISTS transactions (
id INT AUTO_INCREMENT PRIMARY KEY,
type ENUM('income', 'expense') NOT NULL, -- عواید یا مصارف
category VARCHAR(50) NOT NULL, -- مثل: فیس شاگرد، معاش استاد، کرایه، برق
amount DECIMAL(10, 2) NOT NULL, -- مبلغ به افغانی
student_id VARCHAR(20) DEFAULT NULL, -- اگر عواید از بابت فیس شاگرد باشد
teacher_id INT DEFAULT NULL, -- اگر مصرف از بابت معاش استاد باشد
description TEXT DEFAULT NULL,
transaction_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE SET NULL ON UPDATE CASCADE,
FOREIGN KEY (teacher_id) REFERENCES teachers(id) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;

---

-- ۹. درج اطلاعات پیش‌فرض ادمین جهت ورود اولیه به سیستم
-- نام کاربری: amajadmin | رمز عبور رمزگذاری شده (معادل متن ساده: amaj1405)
INSERT INTO users (username, password, full_name, role, status)
VALUES ('amajadmin', '$2y$10$7zR8zWp9p7/9X8zWp9p7/.uX8zWp9p7/9X8zWp9p7/.uX8zWp9p7/', 'مدیریت کل آماج', 'admin', 'active')
ON DUPLICATE KEY UPDATE id=id;

[github-actions[bot]]

💬 Your Product Feedback Has Been Submitted 🎉

Thank you for taking the time to share your insights with us! Your feedback is invaluable as we build a better GitHub experience for all our users.

Here's what you can expect moving forward ⏩

• Your input will be carefully reviewed and cataloged by members of our product teams. 
  • Due to the high volume of submissions, we may not always be able to provide individual responses.
  • Rest assured, your feedback will help chart our course for product improvements.
• Other users may engage with your post, sharing their own perspectives or experiences. 
• GitHub staff may reach out for further clarification or insight. 
  • We may 'Answer' your discussion if there is a current solution, workaround, or roadmap/changelog post related to the feedback.

Where to look to see what's shipping 👀

• Read the Changelog for real-time updates on the latest GitHub features, enhancements, and calls for feedback.
• Explore our Product Roadmap, which details upcoming major releases and initiatives.

What you can do in the meantime 💻

• Upvote and comment on other user feedback Discussions that resonate with you.
• Add more information at any point! Useful details include: use cases, relevant labels, desired outcomes, and any accompanying screenshots.

As a member of the GitHub community, your participation is essential. While we can't promise that every suggestion will be implemented, we want to emphasize that your feedback is instrumental in guiding our decisions and priorities.

Thank you once again for your contribution to making GitHub even better! We're grateful for your ongoing support and collaboration in shaping the future of our platform. ⭐

[v-ember]

Hi @azadmuhammady2019-commits , thanks for participating!

Unfortunately, we don’t currently have moderators for languages other than English. Until that changes, we need to ask that everyone use English here in the GitHub Community when posting to ensure discussions are adhering to our Code of Conduct.

We’ll be locking this post for now, but please feel encouraged to create a new discussion in English if you still need support.