: .
320201(650)
.
. :
.
.
2014.
1
2
3
4
5
6
7
8
.
, ,
, .
,
, ,
.
, .
,
.
[1]
[2]
[3]
.
[4]
[5]
[6]
[7]
1 -
2 -
Gruppa tovara
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| | Default Value
| Comment
| AutoInc
| Kod tovara
| VARCHAR(20)
| PK
| NN
|
|
|
| AI
| Naimenovanie tovara
| VARCHAR(20)
|
|
|
|
|
|
| |
IndexName
| IndexType
| Columns
| PRIMARY
| PRIMARY
| Kod tovara
| |
:
Menedjer
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| | Default Value
| Comment
| AutoInc
| Kod_Menedjer
| VARCHAR(20)
| PK
| NN
|
|
| ðððîïàíââåí
| AI
| Naimenovanie
| VARCHAR(20)
|
|
|
|
|
|
| INN
| VARCHAR(20)
|
|
|
|
|
|
| Adres
| VARCHAR(20)
|
|
|
|
|
|
| Gorod
| VARCHAR(20)
|
|
|
|
|
|
| |
IndexName
| IndexType
| Columns
| PRIMARY
| PRIMARY
| Kod_Menedjer
| |
: , , .
Operacii
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| | Default Value
| Comment
| AutoInc
| Kod operasii
| INTEGER
| PK
| NN
| UNSIGNED
|
|
| AI
| Menedjer_Kod_Menedjer
| VARCHAR(20)
|
| NN
|
|
|
|
| Tovar_Kod tovara
| INTEGER
|
| NN
| UNSIGNED
|
|
|
| Data operasii
| DATE
|
|
|
|
|
|
| Sena
| VARCHAR(20)
|
|
|
|
|
|
| Kolihestvo
| VARCHAR(20)
|
|
|
|
|
|
| Priznak
| VARCHAR(20)
|
|
|
|
|
|
| |
|
: , , , .
Rashot
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| Flags
| Default Value
| Comment
| AutoInc
| Kod rashota
| VARCHAR(20)
| PK
| NN
|
|
|
| AI
| Operacii_Kod operasii
| INTEGER
|
| NN
| UNSIGNED
|
|
|
| Summa operacii
| VARCHAR(20)
|
|
|
|
|
|
| Data rashota
| DATE
|
|
|
|
|
|
| |
|
: , ,.
Shot
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| Flags
| Default Value
| Comment
| Auto
| Kod shota
| VARCHAR(20)
| PK
| NN
|
|
|
| AI
| Menedjer_Kod_Menedjer
| VARCHAR(20)
|
| NN
|
|
|
|
| Bank
| VARCHAR(20)
|
|
|
|
|
|
| Rashotnii shot
| VARCHAR(20)
|
|
|
|
|
|
| Kor.Shot
| VARCHAR(20)
|
|
|
|
|
|
| BIK
| VARCHAR(20)
|
|
|
|
|
|
| |
|
: , , , .
Telefons
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| Flags
| Default Value
| Comment
| Auto
| Kod telefons
| VARCHAR(20)
| PK
| NN
|
|
|
| AI
| Menedjer_Kod_Menedjer
| VARCHAR(20)
|
| NN
|
|
|
|
| Nomer
| VARCHAR(20)
|
|
|
|
|
|
| |
IndexName
| IndexType
| Columns
| PRIMARY
| PRIMARY
| Kod telefons
| | | | |
: , ,
Tovar
|
ColumnName
| DataType
| PrimaryKey
| NotNull
| Flags
| Default Value
| Comment
| AutoInc
| Kod tovara
| INTEGER
| PK
| NN
| UNSIGNED
|
|
| AI
| Gruppa tovara_Kod tovara
| VARCHAR(20)
|
| NN
|
|
|
|
| Naimenovanie tovara
| VARCHAR(20)
|
|
|
|
|
|
| Artikul
| VARCHAR(20)
|
|
|
|
|
|
| Proizvodstvop
| VARCHAR(20)
|
|
|
|
|
|
| |
IndexName
| IndexType
| Columns
| PRIMARY
| PRIMARY
| Kod tovara
| | | | |
:
select * from Tovar
Telefon
insert into Telefon values (343, 56785678967,5658hk568);