此地址:http://en.wikipedia.org/wiki/Associative_Entities
中的一个例子将关联表的名字取名为registers,我觉得怪怪的。
大家觉得 student与course这种多对多关系的关联表取什么名字比较好呢?
------
熟悉SQLAlchemy的看看如何写比较适合?
class Association(Base):
student_id = Column(Integer,ForeignKey('student.id').primary_key=True)
subject_id = Column(Integer,ForegnKey('subject.id').priamry_key=True)
extra_data = Column(String(50))
course = relationship("Course")
class Student(Base):
id = Column(Integer,primary_key=True)
sno = Column(String(20),unique=True)
subject_associations = relationship("Association")
class Course(Base):
id = Column(Integer,priamry_key=True)
name = Column(String(20))
中的一个例子将关联表的名字取名为registers,我觉得怪怪的。
大家觉得 student与course这种多对多关系的关联表取什么名字比较好呢?
------
熟悉SQLAlchemy的看看如何写比较适合?
class Association(Base):
student_id = Column(Integer,ForeignKey('student.id').primary_key=True)
subject_id = Column(Integer,ForegnKey('subject.id').priamry_key=True)
extra_data = Column(String(50))
course = relationship("Course")
class Student(Base):
id = Column(Integer,primary_key=True)
sno = Column(String(20),unique=True)
subject_associations = relationship("Association")
class Course(Base):
id = Column(Integer,priamry_key=True)
name = Column(String(20))