13 lines
614 B
Python
13 lines
614 B
Python
from sqlalchemy import Column, Integer, DateTime, ForeignKey, Date
|
|
from sqlalchemy.sql import func
|
|
from .database import Base
|
|
|
|
class CouponReceiveRecordDB(Base):
|
|
__tablename__ = "coupon_receive_records"
|
|
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
|
user_id = Column(Integer, ForeignKey("users.userid"), index=True)
|
|
activity_id = Column(Integer, ForeignKey("coupon_activities.id"))
|
|
receive_date = Column(Date, nullable=False)
|
|
receive_count = Column(Integer, nullable=False, default=1) # 领取次数
|
|
create_time = Column(DateTime(timezone=True), server_default=func.now()) |