anggota
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_anggota (Primary) | int(50) | No | ||||
| nim | varchar(50) | Yes | NULL | |||
| nama_anggota | varchar(50) | Yes | NULL | |||
| tempat_lahir | varchar(40) | Yes | NULL | |||
| tgl_lahir | date | Yes | NULL | |||
| jk | enum('Laki-laki', 'Perempuan') | Yes | NULL | |||
| prodi | varchar(30) | Yes | NULL | |||
| thn_masuk | year(4) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_anggota | 0 | A | No |
buku
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kode_buku (Primary) | varchar(50) | No | ||||
| nama_dokumen | varchar(5000) | Yes | NULL | |||
| pembuat | varchar(50) | Yes | NULL | |||
| tahun | varchar(50) | Yes | NULL | |||
| ket | text | Yes | NULL | |||
| lampiran | varchar(300) | Yes | NULL | |||
| lokasi | varchar(100) | Yes | NULL | |||
| tgl_input | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kode_buku | 36 | A | No |
file_lelang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_file_lelang (Primary) | int(100) | No | ||||
| id_lelang | int(50) | Yes | NULL | |||
| nama_file | varchar(200) | Yes | NULL | |||
| tgl_upload | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_file_lelang | 10 | A | No |
legalitas
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_legalitas (Primary) | int(30) | No | ||||
| nama_legalitas | varchar(500) | Yes | NULL | |||
| nomor | varchar(500) | Yes | NULL | |||
| tgl_legalitas | varchar(400) | Yes | NULL | |||
| masa_berlaku | varchar(400) | Yes | NULL | |||
| waktu_proses | varchar(40) | Yes | NULL | |||
| file_upload | varchar(1000) | Yes | NULL | |||
| status | varchar(50) | Yes | NULL | |||
| persyaratan | varchar(400) | Yes | NULL | |||
| lokasi_pengurusan | varchar(400) | Yes | NULL | |||
| pic | varchar(500) | Yes | NULL | |||
| cara_pengurusan | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_legalitas | 0 | A | No |
lelang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_lelang (Primary) | int(80) | No | ||||
| projek | varchar(500) | Yes | NULL | |||
| OPD | varchar(500) | Yes | NULL | |||
| kabkota | varchar(400) | Yes | NULL | |||
| tahun | year(4) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_lelang | 37 | A | No |
log_legalitas
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_log | int(255) | No | ||||
| username | varchar(500) | Yes | NULL | |||
| field_legalitas | varchar(500) | Yes | NULL | |||
| id_legalitas | int(255) | Yes | NULL | |||
| keterangan | varchar(500) | Yes | NULL | |||
| tgl | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| id_log | BTREE | No | No | id_log | 0 | A | No |
pengembalian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_kembali (Primary) | int(40) | No | ||||
| kode_buku | varchar(40) | Yes | NULL | |||
| nama_dokumen | varchar(50) | Yes | NULL | |||
| pembuat | varchar(50) | Yes | NULL | |||
| nama_anggota | varchar(50) | Yes | NULL | |||
| tgl_pinjam | date | Yes | NULL | |||
| tgl_kembali | date | Yes | NULL | |||
| lama_pinjam | varchar(50) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_kembali | 0 | A | No |
transaksi
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_transaksi (Primary) | int(40) | No | ||||
| kode_buku | varchar(30) | Yes | NULL | |||
| nama_dokumen | varchar(40) | Yes | NULL | |||
| pembuat | varchar(40) | Yes | NULL | |||
| nama_anggota | varchar(50) | Yes | NULL | |||
| tgl_pinjam | date | Yes | NULL | |||
| tgl_kembali | date | Yes | NULL | |||
| ket | varchar(60) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_transaksi | 0 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_user (Primary) | int(60) | No | ||||
| nama_user | varchar(50) | Yes | NULL | |||
| username | varchar(50) | Yes | NULL | |||
| pwd | varchar(50) | Yes | NULL | |||
| varchar(50) | Yes | NULL | ||||
| foto | varchar(50) | Yes | NULL | |||
| lvl | enum('admin', 'user') | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_user | 3 | A | No |