10 UMLClass 0 60 210 220 _table: persons_ -- id: autoincrement name: short text[30] surname: short text[30] pesel: short text[11] street: short text[30] addr_num: short text[5] loc_num: short text[5] town_id: number email: short text[80] sitewww: short text[100] telephone: short text[14] UMLClass 980 480 210 140 _table: invoices_ -- id: autoincrement date: date_time seller_id: number paper_number: short_text[20] payment: short text[20] payment_date: date_time payed: bool UMLClass 490 0 210 120 _table: clients_ -- id: autoincrement person_id: number login: short text[20] password: short text[32] company_id: number UMLClass 260 360 210 110 _table: workers_ -- id: autoincrement person_id: number login: short text[20] password: short text[32] department: number UMLClass 250 500 210 80 _table: departments_ -- id: autoincrement name: short text[100] description: long text UMLClass 730 350 210 160 _table: instruments_ -- id: autoincrement name: short text[100] description: long text category_id: number dimmension: short text[17] material: short text[60] producer_id: number UMLClass 480 400 210 120 _table: categories_ -- id: autoincrement name: short text[30] description: long text subcategory_id: number UMLClass 470 540 210 120 _table: subcategories_ -- id: autoincrement name: short text[30] description: long text UMLClass 740 530 210 130 _table: storehouse_ -- id: autoincrement instrument_id: number maintenance_id: number current_status: number UMLClass 1000 100 210 160 _table: boughts_ -- id: autoincrement storehouse_id: number date: date_time deliver_id: number worker_id: number amount: number price_per_piece: number tax: number UMLClass 990 280 210 160 _table: solds_ -- id: autoincrement storehouse_id: number date: date_time buyer_id: number worker_id: number amount: number price_per_piece: number tax: number UMLClass 500 160 210 90 _table: delivers_ -- id: autoincrement person_id: number company_id: number UMLClass 730 90 210 240 _table: companies_ -- id: autoincrement name: short text[100] owners: short text[100] nip: short text[12] iban: short text[30] swift: short text[20] telephone: short text[14] email: short text[100] street: short text[30] addr_num: short text[5] loc_num: short text[5] town_id: number UMLClass 500 270 200 120 _table: towns_ -- id: autoincrement name: krotki tekst[100] zip: krotki tekst[5] Relation 200 40 310 70 lt=<- layer=3 10.0;50.0;290.0;10.0 Relation 200 80 320 150 lt=<- layer=3 10.0;10.0;300.0;130.0 Relation 200 90 80 340 lt=<- layer=3 10.0;10.0;60.0;320.0 Relation 680 430 70 30 lt=<- layer=3 10.0;10.0;50.0;10.0 Relation 670 470 40 120 lt=<- 10.0;100.0;20.0;10.0