pgsql_zlotemysli: partner_provisions: _attributes: { phpName: OldPartnerProvision, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } parent_id: { type: integer, required: false, index: true, foreignTable: partner_provisions, foreignReference: id, onDelete: cascade } created_at: { type: timestamp, required: true } updated_at: { type: timestamp, required: true } partner_id: { type: integer, required: true } order_id: { type: integer, required: true } type: { type: integer, required: true } amount: { type: double, required: true, default: 0 } status: { type: integer, required: true, default: 1 } source: { type: integer, required: true, default: 1 } partner_provisions_cache: _attributes: { phpName: OldPartnerProvisionCache, baseClass: BaseModel } partner_id: { type: integer, required: true, primaryKey: true } date_from: { type: date, required: true, primaryKey: true } date_to: { type: date, required: true, primaryKey: true } provisions_l1d: { type: double, required: true, default: 0 } provisions_l1e: { type: double, required: true, default: 0 } provisions_l2d: { type: double, required: true, default: 0 } provisions_l2e: { type: double, required: true, default: 0 } provisions_manual: { type: double, required: true, default: 0 } provisions_total: { type: double, required: true, default: 0 } partner_provisions_payments: _attributes: { phpName: OldPartnerProvisionPayment, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } created_at: { type: timestamp, required: true } updated_at: { type: timestamp, required: true } partner_id: { type: integer, required: true } amount: { type: double, required: true } status: { type: integer, required: true, default: 1 } information: { type: varchar(255), required: false } orders: _attributes: { phpName: OldOrder, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } date: { type: timestamp, required: true } users_id: { type: integer, required: true, default: -1 } state: { type: integer, required: true, default: 0 } price: { type: double, required: true, default: 0 } kod: { type: varchar(255), required: false } miasto: { type: varchar(255), required: false } adres: { type: varchar(255), required: false } fnazwa: { type: varchar(255), required: false } fkod: { type: varchar(255), required: false } fmiasto: { type: varchar(255), required: false } fadres: { type: varchar(255), required: false } session_id: { type: varchar(255), required: false } faktura: { type: boolean, required: true, default: false } partner_id: { type: integer, required: true, default: 0 } used_gp: { type: integer, required: false } gp: { type: integer, required: true, default: 0 } discount: { type: integer, required: true, default: 0 } wysylka_imie: { type: varchar(255), required: false } wysylka_nazwisko: { type: varchar(255), required: false } campaign: { type: varchar(255), required: false } realized: { type: timestamp, required: false } codes_id: { type: integer, required: true, default: 0 } ordered_versions: _attributes: { phpName: OldOrderItem, baseClass: BaseModel } version_id: { type: integer, required: true, primaryKey: true, foreignTable: versions, foreignReference: id, onDelete: restrict } orders_id: { type: integer, required: true, primaryKey: true, foreignTable: orders, foreignReference: id, onDelete: restrict } token: { type: varchar(255), required: true } price: { type: double, required: true } quantity: { type: integer, required: true, default: 1 } flags: { type: integer, required: true, default: 0 } lastmodified: { type: date, required: true } publications: _attributes: { phpName: OldPublication, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } user_id: { type: integer, required: false, foreignTable: users, foreignReference: id } title: { type: longvarchar, required: false } original: { type: longvarchar, required: false } category_id: { type: integer, required: false } #FIXME added: { type: timestamp, required: true } image: { type: integer, required: false } description: { type: longvarchar, required: false } author_id: { type: integer, required: false, foreignTable: users, foreignReference: id } image3d: { type: integer, required: false } metatitle: { type: longvarchar, required: false } metadescription: { type: longvarchar, required: false } metakeywords: { type: longvarchar, required: false } subdomain: { type: longvarchar, required: false } visible: { type: integer, required: true, default: 2 } short: { type: longvarchar, required: false } prepared: { type: integer, required: true, default: 0 } last_modified: { type: timestamp, required: true } index: { type: longvarchar, required: false } id_ebook: { type: integer, required: false } bonus: { type: longvarchar, required: false } is_training: { type: boolean, required: true, default: false } versions: _attributes: { phpName: OldPublicationVersion, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } publications_id: { type: integer, required: true, foreignTable: publications, foreignReference: id, index: true } version: { type: integer, required: true, default: 0 } files_id: { type: integer, required: true } pages: { type: integer, required: false } pub_date: { type: date, required: false } isbn: { type: varchar(255), required: false } added: { type: timestamp, required: true } price: { type: double, required: true, default: 0 } nr: { type: varchar(255), required: false } isbn2: { type: varchar(255), required: false } id_ebook: { type: integer, required: false } date_start: { type: timestamp, required: true } date_end: { type: timestamp, required: false } minimalna_kwota: { type: double, required: false } uciekajaca_cena_pocz: { type: double, required: false } uciekajaca_skok: { type: double, required: false } cena_promocyjna: { type: double, required: false } zp: { type: boolean, required: true, default: true } vat: { type: integer, required: true, default: 0 } lektor: { type: varchar(255), required: false } preorder: { type: boolean, required: true, default: false } inbonus: { type: boolean, required: false } bonusamount: { type: double, required: false } users: _attributes: { phpName: OldUser, baseClass: BaseModel } id: { type: integer, required: true, primaryKey: true, autoIncrement: true } imie: { type: longvarchar, required: false } nazwisko: { type: longvarchar, required: false } email: { type: longvarchar, required: false } role: { type: integer, required: false } login: { type: longvarchar, required: false } password: { type: longvarchar, required: false } lastlogin: { type: timestamp, required: false } created: { type: timestamp, required: true } telefon: { type: longvarchar, required: false } parent_id: { type: integer, required: true, default: 0 } confirmed: { type: boolean, required: true, default: true } id_author: { type: integer, required: false } ebook_pass: { type: longvarchar, required: false } gp: { type: integer, required: true, default: 0 } discount: { type: integer, required: true, default: 0 } id_partner: { type: integer, required: true, default: 0 } description: { type: longvarchar, required: false } approved_by_author: { type: timestamp, required: false } credentials: { type: integer, required: true, default: 0 }