Sequelize как правильно создать связи?
Пи создании связи , создаются пустые столбцы и неверно отображается в диаграмме (например указал связь 1:1 ) , а показывает как 1:N
db.MainInfo.hasMany(db.Podlesok)
db.MainInfo.hasMany(db.Podrostok)
db.MainInfo.hasMany(db.Jnp)
/* db.MainInfo.hasOne(db.Privazka)
db.MainInfo.hasOne(db.Lesoseka)
*/
db.Privazka.hasOne(db.Geo)
db.Lesoseka.hasOne(db.Geo)
module.exports = (sequelize, Sequelize) => {
const Privazka = sequelize.define('lc_privazka', {
geom: Sequelize.GEOMETRY,
coordinates: Sequelize.STRING,
id_lc: {
type: Sequelize.STRING,
primaryKey: true,
},
})
return Privazka
}
module.exports = (sequelize, Sequelize) => {
const Privazka = sequelize.define('lc_privazka', {
geom: Sequelize.GEOMETRY,
coordinates: Sequelize.STRING,
id_lc: {
type: Sequelize.STRING,
primaryKey: true,
},
})
return Privazka
}
module.exports = (sequelize, Sequelize) => {
const Geo = sequelize.define('lc_geo', {
id: {
type:Sequelize.INTEGER,
autoIncrement:true,
primaryKey:true
},
azimuth: Sequelize.STRING,
coordinate_x: Sequelize.STRING,
coordinate_y: Sequelize.STRING,
direction_angle: Sequelize.STRING,
horizontal_distance: Sequelize.STRING,
rhumb: Sequelize.STRING,
slant_distance: Sequelize.STRING,
vertical_angle: Sequelize.STRING,
is_binding_line: Sequelize.BOOLEAN,
id_lc:{
type: Sequelize.STRING,
foreignKey:true,
},
});
return Geo
}
module.exports = (sequelize, Sequelize) => {
const MainInfo = sequelize.define('lc_info', {
code_lesxoz: Sequelize.INTEGER,
code_plxo: Sequelize.INTEGER,
code_lestichestva: Sequelize.INTEGER,
number_vided: Sequelize.INTEGER,
number_kvartala: Sequelize.INTEGER,
number_region: Sequelize.INTEGER,
number_lesoseka: Sequelize.INTEGER,
x_center: Sequelize.STRING,
y_scenter: Sequelize.STRING,
id_lc: {
type: Sequelize.STRING,
primaryKey: true,
},
})
return MainInfo
}

