baza fiz

magazyn

_J unit	Y
id_unit INT
name VARCHAR(20)
| O id_author INT
lndexes	►

warehouse

warehouse_store y

łł-

_J product	Y
id_product INT
O name VARCHAR(100)
price FLOAT
^ id_unit INT
va lid rty DATĘ
s> id_author INT

>|----

-U-

T

I

-K

id_warehouse_store INT > id_warehouse INT id_product INT section_num INT • place_num INT count FLOAT id author INT

>1-

id_warehouse INT localization VARCHAR(128) id author INT

lndexes

=F

I

I

T

I

I

I

“T

I task

centrala

-K

wholesale_item

warehouse_operation y

-K

detal_item

lndexes	►

-K

operation_element y

>F

id_warehouse_operation INT id_pfoduct INT count FLOAT id author INT

lndexes	►

id_warehouse_operation INT type ENUMCPZ-.-WZ) datę DATETIME contractor VARCHAR(128)

> id_warehouse INT id author INT

lndexes

•H-

idjask INT

task_contents VARCHAR(256) O realization TINYINT

>    id_warehouse INT id_principal INT

>    id_executor INT id author INT

lndexes	►
W

-K

id_product INT id_detal_order INT count FLOAT id author INT

lndexes

Y

-K

id_wholesale_order INT id_product INT count FLOAT id author INT

wholesale_order y

Ksiegowosc

payment

id_payment INT value FLOAT type ENUM(...) datę DATETIME description VARCHAR(256) id_employee INT id author INT

lndexes

użytkownicy

^— employee

id_employee INT name VARCHAR(45) su ma me VA RC H A R (45) approval_date DATĘ id_position INT salary FLOAT O start TIME O stop TIME O timezone TINYINT id author INT

H-

H-

J

-K

detal_order	Y
id_detal_order INT
datę DATETIME
contractor VARCHAR(128)
State ENUM(...)
j id_handlerlNT
O id_author INT
lndexes	►

id_wholesale_order INT datę DATETIME contractor VARCHAR(128) State ENUM(...)

> id_handlerlNT id author INT

-11-

>l-

4.

T

i

i

position

id_position INT name VARCHAR(45) id author INT

security

I

=F

permission

auth

permissionjd INT columnsjd INT ■> id_role INT OregexpVARCHAR(256)

O condition VARCHAR(256)

-K enumeration VARCHAR(45) id_query INT rights TINYINT tabel_name VARCHAR(45) column_name VARCHAR(45) id author INT

lndexes	►
V- -

id_auth INT - login VARCHAR(20) password CHAR(32)

O lastjogin DATETIME last_change DATETIME id_employee INT id author INT

lndexes	►
..

H-----

J owner	Y
id_owner INT
table VARCHAR(45)
target INT
* id_auth INT
O id_author INT

□ query

role

auth_role

id_query INT O name VARCHAR(45)

O codę VARCHAR(2048) id author INT

id_role INT name VARCHAR(45) id author INT

lndexes

lndexes

id_role INT id_auth INT conferment_date DATETIME Ocomments VARCHAR(45) id author INT

lndexes	►

VI