102 |
102 |
103 # total quantity, or NULL for uncounted items |
103 # total quantity, or NULL for uncounted items |
104 Column('quantity', Integer, nullable=True), |
104 Column('quantity', Integer, nullable=True), |
105 ) |
105 ) |
106 |
106 |
107 ## items included in order |
107 # items included in order |
108 #order_items = Table('order_items', schema, |
108 order_items = Table('order_items', schema, |
109 # # order we are part of |
109 # order we are part of |
110 # Column('order_id', None, ForeignKey('orders.id'), primary_key=True), |
110 Column('order_id', None, ForeignKey('orders.id'), primary_key=True), |
111 # |
111 |
112 # # which item is selected |
112 # which item is selected |
113 # Column('item_id', None, ForeignKey('items.id'), primary_key=True), |
113 Column('item_id', None, ForeignKey('items.id'), primary_key=True), |
114 # |
114 |
115 # # how many out of total quantity |
115 # how many out of total quantity |
116 # Column('quantity', Integer, nullable=True), |
116 Column('quantity', Integer, nullable=True), |
117 #) |
117 ) |
118 |
118 |
119 ## editable contract terms for customer order |
119 ## editable contract terms for customer order |
120 ## provision for standard terms, or more specific ones for certain customers |
120 ## provision for standard terms, or more specific ones for certain customers |
121 #contract_terms = Table('contract_terms', schema, |
121 #contract_terms = Table('contract_terms', schema, |
122 # Column('id', Integer, primary_key=True), |
122 # Column('id', Integer, primary_key=True), |