Skip to content

Instantly share code, notes, and snippets.

@andresgardiol
Created May 11, 2018 15:20
Show Gist options
  • Save andresgardiol/07f3995fe888d8ea7695417b8873051b to your computer and use it in GitHub Desktop.
Save andresgardiol/07f3995fe888d8ea7695417b8873051b to your computer and use it in GitHub Desktop.
group: Recargas y viajes tarjeta SUBE
Tar = {
num:number, monto:number, dni:number, nombre:string, prov:string
001 , 100 , 39026 , 'Guille' , 'San Juan'
002 , 150 , 39027 , 'Franco' , 'San Juan'
003 , 75 , 40028 , 'Luis' , 'San Luis'
004 , 150 , 40029 , 'Martin' , 'Mendoza'
}
LIN = {
codlinea:string, cuit:number
'17' , 2001
'40' , 2001
'36' , 2002
'26A' , 2004
'16' , 2003
'17' , 2003
}
EMP = {
cuit:number, nom_emp:string, direc:string, prov:string
2001 , 'La Positiva', 'Brasil 123', 'San Juan'
2002 , 'El Triunfo' , 'Ella 456' , 'San Juan'
2003 , 'Santa Maria', 'Japish 789' , 'San Luis'
2004 , 'Mayo' , '25 de mayo 321', 'San Juan'
}
V = {
num:number,fecha:date,hora:number,codlinea:string,cuit_emp:number,importe:number
001 , 2016-03-02, 15.03, '36', '2002', 3.20
002 , 2016-03-02, 17.15, '26A', '2004', 13.12
001 , 2016-03-02, 17.25, '26A', '2004', 3.20
004 , 2016-03-02, 19.50, '17', '2001', 3.20
004 , 2016-03-02, 21.30, '17', '2001', 3.20
003 , 2016-04-02, 17.30, '17' , '2003', 4.30
003 , 2016-04-02, 19.45, '17' , '2003', 4.30
001 , 2016-05-02, 15.00, '40' , '2001', 3.20
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment