Column |
Type |
Null |
Default |
kode_kar |
char(10) |
No |
|
nama_kar |
varchar(30) |
No |
|
tgl_lahir |
date |
No |
|
t_lahir |
varchar(30) |
No |
|
j_kelamin |
char(9) |
No |
|
alamat |
char(30) |
Yes |
NULL |
kota |
varchar(30) |
No |
|
jabatan |
varchar(30) |
No |
|
hp |
varchar(14) |
No |
|
tgl_masuk |
date |
No |
1 |
Lady Safikha |
1984-11-01 |
Padang Panjang |
Perempuan |
Jl.M.Yamin |
Jakarta |
Manager |
083418153752 |
2010-01-01 |
2 |
Oria Kartina |
1992-10-05 |
Jakarta |
Perempuan |
Jl.Sartika |
Bogor |
Assistant Manager |
089474373518 |
2011-06-06 |
3 |
Dian Pertiwi |
1990-07-08 |
Bali |
Perempuan |
Jl.Batura |
Jakarta Selatan |
Kepala Bagian Pemasaran |
011194385474 |
2014-05-12 |
Column |
Type |
Null |
Default |
kode_mes |
char(10) |
No |
|
merek_mes |
char(20) |
Yes |
NULL |
kapasitas |
char(20) |
Yes |
NULL |
kecepatan |
char(20) |
Yes |
NULL |
harga_mes |
char(30) |
Yes |
NULL |
kode_supp |
char(10) |
Yes |
NULL |
232 |
sanyo |
50 kg |
100/s |
50.000.000 |
S101 |
345 |
panasonic |
80kg |
100/2 |
75.000.000 |
S112 |
573 |
juki |
75kg |
120/s |
80.000.000 |
S115 |
Column |
Type |
Null |
Default |
no_reg |
char(10) |
No |
|
nama_plgn |
varchar(30) |
No |
|
kode_mes |
char(10) |
No |
|
j_kelamin |
varchar(9) |
No |
|
tgl_lahir |
date |
No |
|
t_lahir |
varchar(30) |
No |
|
alamat |
varchar(30) |
No |
|
kota |
varchar(30) |
No |
|
hp |
varchar(14) |
No |
100001 |
Santika |
232 |
Perempuan |
1985-07-08 |
Yogyakarta |
Jl.Srilengi |
Depok |
0987543322356 |
100018 |
jaka |
573 |
Laki-laki |
1990-01-03 |
Padang |
Jl.Suradi |
Jakarta Utara |
089472674829 |
100020 |
Agus |
345 |
Laki-laki |
1978-05-05 |
Bali |
Jl.Cilenyi |
Jakarta Barat |
098765456789 |
100028 |
Susan |
345 |
Perempuan |
1989-02-03 |
Bekasi |
Jl.Srigunting |
Bandung |
098437836485 |
100030 |
Junaidi |
573 |
Laki-laki |
1984-12-03 |
Medan |
Jl.Cendrawasih |
Bogor |
082930385968 |
Column |
Type |
Null |
Default |
kode_supp |
char(10) |
No |
|
nama_supp |
char(30) |
No |
|
alamat_supp |
char(30) |
Yes |
NULL |
kota_supp |
char(30) |
Yes |
NULL |
hp_supp |
char(14) |
Yes |
NULL |
S101 |
Jainudin |
Jl.merdeka 1 |
Jakarta Selatan |
086372838462 |
S112 |
Susanti |
Jl.Padri |
Bekasi |
098727462818 |
S115 |
Zarka |
Jl.cikla |
Bogor |
082381791434 |
Column |
Type |
Null |
Default |
kode_trans |
char(10) |
No |
|
no_reg |
char(10) |
Yes |
NULL |
tanggal |
date |
Yes |
NULL |
kode_kar |
char(10) |
Yes |
NULL |
kode_mes |
char(10) |
Yes |
NULL |
j_pembelian |
char(50) |
Yes |
NULL |
harga |
char(50) |
Yes |
NULL |
tot_bayar |
char(50) |
Yes |
NULL |
pembayaran |
char(50) |
Yes |
NULL |
bank |
char(20) |
Yes |
NULL |
T100 |
100001 |
2020-08-09 |
1 |
573 |
10 |
150.000 |
1.500.000 |
LUNAS |
BCA |
T111 |
100018 |
2020-06-06 |
2 |
232 |
100 |
500.000 |
50.000.000 |
KREDIT |
BNI |
Tags: 1944370002 ================, 1944370002, safikha