1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- from sqlalchemy import Column, Integer, String, ForeignKey, TIMESTAMP
- from sqlalchemy.orm import relationship
- from app.db.session import Base
- class MeetingInfo(Base):
- __tablename__ = 'meetings_info'
- id = Column(String, primary_key=True, index=True)
- initiator_id = Column(String, ForeignKey('tenantslink_users.id'))
- room_id = Column(String, ForeignKey('meeting_rooms_info.id'))
- start_time = Column(TIMESTAMP)
- end_time = Column(TIMESTAMP)
- topic = Column(String)
- status = Column()
- initiator = relationship('TenantslinkUser', back_populates='meetings_info')
- room = relationship('MeetingRoom', back_populates='meetings_info')
- class MeetingRoom(Base):
- __tablename__ = 'meeting_rooms_info'
- id = Column(String, primary_key=True, index=True)
- name = Column(String)
- location = Column(String)
- category = Column(String)
- seat_count = Column(Integer)
- class MeetingAttendee(Base):
- __tablename__ = 'meeting_attendees'
- meeting_id = Column(String, index=True)
- user_id = Column(String, index=True)
- class TenantslinkUser(Base):
- __tablename__ = 'tenantslink_users'
- id = Column(String, primary_key=True, index=True)
- name = Column(String)
|