Perancangan
Database
Struktur Tabel Database “SISKOST”
3NF
t_petugas
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
username
|
varchar
|
12
|
PK
|
|
|
2
|
password
|
varchar
|
8
|
-
|
|
|
3
|
kode_level
|
char
|
1
|
FK
|
_level_petugas
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
kode_level
|
char
|
1
|
PK
|
|
|
2
|
level
|
varchar
|
15
|
-
|
penyewa
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
kode_penyewa
|
char
|
5
|
PK
|
|
|
2
|
nama_penyewa
|
varchar
|
15
|
-
|
|
|
3
|
jenis_kelamin
|
char
|
1
|
-
|
|
|
4
|
Status
|
varchar
|
15
|
-
|
|
|
5
|
pekerjaan
|
varchar
|
25
|
-
|
|
|
6
|
umur
|
int
|
3
|
-
|
|
|
7
|
kode_kecamatan
|
char
|
5
|
FK
|
|
|
8
|
kode_kabupaten
|
char
|
5
|
FK
|
|
|
9
|
kode_provinsi
|
char
|
5
|
FK
|
t_kamar
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
kode_kamar
|
char
|
5
|
PK
|
|
|
2
|
luas_kamar
|
int
|
1
|
-
|
|
|
3
|
harga_kamar
|
money
|
8
|
-
|
|
|
4
|
keterangan
|
varchar
|
25
|
-
|
t_fasilitas
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
kode_fasilitas
|
char
|
5
|
PK
|
|
|
2
|
nama_fasilitas
|
varchar
|
50
|
-
|
t_fasilitas_kamar
|
No
|
Nama field
|
Tipe
|
Ukuran
|
Key
|
Keterangan
|
|
1
|
kode_kamar
|
char
|
5
|
PK
|
|
|
2
|
kode_fasilitas
|
varchar
|
50
|
PK
|
|
|
3
|
harga
|
money
|
8
|
-
|
No comments:
Post a Comment