import { PrimaryGeneratedColumn, Entity, Column } from "typeorm"; @Entity("com_comercios", { synchronize: false }) export class Comercio { @PrimaryGeneratedColumn({ name: "id_comercio", type: "int" }) id: number; @Column({ name: "nombre", type: "varchar", length: 150 }) nombre: string; @Column({ name: "nombre_corto", type: "varchar", length: 100 }) nombreCorto: string; @Column({ name: "tags", type: "varchar", length: 255 }) tags: string; @Column({ name: "id_categoria", type: "int" }) idCategoria: number; @Column({ name: "id_ciudad", type: "int" }) idCiudad: number; @Column({ name: "nit", type: "varchar", length: 15 }) nit: string; @Column({ name: "direccion_contacto", type: "varchar", length: 200 }) direccionContacto: string; @Column({ name: "telefono_contacto", type: "varchar", length: 200 }) telefonoContacto: string; @Column({ name: "logo", type: "varchar", length: 400 }) logo: string; @Column({ name: "miembros", type: "int" }) miembros: number; @Column({ name: "url_facebook", type: "varchar", length: 300 }) urlFacebook: string; @Column({ name: "url_twitter", type: "varchar", length: 300 }) urlTwitter: string; @Column({ name: "url_instagram", type: "varchar", length: 300 }) urlInstagram: string; @Column({ name: "url_web", type: "varchar", length: 300 }) urlWeb: string; @Column({ name: "uid_cms", type: "varchar", length: 32 }) uidCms: string; @Column({ name: "puntos_termometro", type: "int" }) puntosTermometro: number; @Column({ name: "puntos_facebook", type: "int" }) puntosFacebook: number; @Column({ name: "dias_campana", type: "int" }) diasCampana: number; @Column({ name: "estado", type: "varchar", length: 10 }) estado: string; @Column({ name: "email", type: "varchar", length: 100 }) email: string; @Column({ name: "correo_campana", type: "varchar", length: 150 }) correoCampana: string; @Column({ name: "puntos_unirse", type: "int" }) puntosUnirse: number; @Column({ name: "img_fondo_app", type: "varchar", length: 150 }) fondoApp: string; @Column({ name: "descripcion", type: "text" }) descripcion: string; @Column({ name: "horario", type: "text" }) horario: string; @Column({ name: "card_nuevos", type: "varchar", length: 150 }) cardNuevos: string; @Column({ name: "visible_app", type: "varchar", length: 2 }) visibleApp: string; @Column({ name: "fecha_creacion", type: "datetime" }) fechaCreacion: Date; @Column({ name: "id_plan", type: "int" }) idPlan: number; @Column({ name: "kam", type: "varchar", length: 100 }) kam: string; @Column({ name: "nota_transaccion", type: "varchar", length: 1 }) notaTransaccion: string; @Column({ name: "fecha_apagado", type: "datetime" }) fechaApagado: Date; @Column({ name: "campanas_sms_extra", type: "int" }) campanasSmsExtra: number; @Column({ name: "campanas_email_extra", type: "int" }) campanasEmailExtra: number; @Column({ name: "lc", type: "int" }) lealCoins: number; @Column({ name: "saas", type: "int" }) saas: number; @Column({ name: "transfiere", type: "int" }) transfiere: number; @Column({ name: "tipo_lc", type: "varchar" }) tipoLealCoins: string; constructor( nombre: string, nombre_corto: string, tags: string, id_categoria: number, id_ciudad: number, nit: string, direccion_contacto: string, telefono_contacto: string, logo: string, miembros: number, url_facebook: string, url_twitter: string, url_instagram: string, url_web: string, uid_cms: string, puntos_termometro: number, puntos_facebook: number, dias_campana: number, estado: string, email: string, correo_campana: string, puntos_unirse: number, img_fondo_app: string, descripcion: string, horario: string, card_nuevos: string, visible_app: string, fecha_creacion: Date, id_plan: number, nota_transaccion: string, kam: string, fecha_apagado: Date, campanas_sms_extra: number, campanas_email_extra: number, lealCoins: number, saas: number, transfiere: number, tipoLealCoins: string ) { this.id = 0; this.nombre = nombre; this.nombreCorto = nombre_corto; this.tags = tags; this.idCategoria = id_categoria; this.idCiudad = id_ciudad; this.nit = nit; this.direccionContacto = direccion_contacto; this.telefonoContacto = telefono_contacto; this.logo = logo; this.miembros = miembros; this.urlFacebook = url_facebook; this.urlTwitter = url_twitter; this.urlInstagram = url_instagram; this.urlWeb = url_web; this.uidCms = uid_cms; this.puntosTermometro = puntos_termometro; this.puntosFacebook = puntos_facebook; this.diasCampana = dias_campana; this.estado = estado; this.email = email; this.correoCampana = correo_campana; this.puntosUnirse = puntos_unirse; this.fondoApp = img_fondo_app; this.descripcion = descripcion; this.horario = horario; this.cardNuevos = card_nuevos; this.visibleApp = visible_app; this.fechaCreacion = fecha_creacion; this.idPlan = id_plan; this.notaTransaccion = nota_transaccion; this.kam = kam; this.fechaApagado = fecha_apagado; this.campanasSmsExtra = campanas_sms_extra; this.campanasEmailExtra = campanas_email_extra; this.lealCoins = lealCoins; this.saas = saas; this.transfiere = transfiere; this.tipoLealCoins = tipoLealCoins; } }