构建基于学工系统的贵阳高校数据管理平台

# 导入必要的库

from django.db import models

class Student(models.Model):

name = models.CharField(max_length=100)

age = models.IntegerField()

major = models.CharField(max_length=50)

class Teacher(models.Model):

name = models.CharField(max_length=100)

department = models.CharField(max_length=50)

email = models.EmailField(unique=True)

]]>

CREATE TABLE student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100) NOT NULL,

age INT NOT NULL,

major VARCHAR(50)

);

CREATE TABLE teacher (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100) NOT NULL,

department VARCHAR(50),

email VARCHAR(100) UNIQUE

);

]]>

]]>