29 lines
1010 B
Python
29 lines
1010 B
Python
from sqlalchemy import *
|
|
from datetime import datetime
|
|
from database import *
|
|
class Employment(Base):
|
|
__tablename__ = 's_employment'
|
|
id = Column(Integer
|
|
, primary_key=True
|
|
, autoincrement=True
|
|
, comment='编号,自增主键')
|
|
stu_id = Column(String(20),
|
|
ForeignKey('s_student.stu_id')
|
|
, unique=True
|
|
, nullable=True
|
|
, comment='学生学号，唯一')
|
|
class_name = Column(String(32))
|
|
company = Column(String(100))
|
|
salary = Column(Integer
|
|
, default=0)
|
|
open_date = Column(DATETIME
|
|
, default=datetime.now())
|
|
offer_date = Column(DATETIME
|
|
, default=datetime.now())
|
|
work_date = Column(DATETIME
|
|
, default=datetime.now()
|
|
, onupdate=datetime.now)
|
|
is_deleted = Column(Integer
|
|
, default=0
|
|
)
|