| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_barang_keluar (Primary) | int(10) | No | ||||
| instruksi | varchar(50) | No | ||||
| nama_barang | varchar(70) | No | ||||
| tanggal | date | No | ||||
| jumlah | int(10) | No | ||||
| keperluan | varchar(150) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_barang_keluar | 6 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_barang_masuk (Primary) | int(10) | No | ||||
| pengirim_barang | varchar(60) | No | ||||
| penerima_barang | varchar(60) | No | ||||
| nama_barang | varchar(60) | No | ||||
| jumlah | int(10) | No | ||||
| tanggal | date | No | ||||
| gambar_barang | varchar(500) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_barang_masuk | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_stok_barang (Primary) | int(10) | No | ||||
| nama_barang | varchar(60) | No | ||||
| stok_barang | int(10) | No | ||||
| harga_barang | varchar(10) | No | ||||
| lokasi_barang | varchar(40) | No | ||||
| gambar_barang | varchar(255) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_stok_barang | 53 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_tes (Primary) | int(10) | No | ||||
| foto | varchar(500) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tes | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| nik_ktp | int(22) | No | ||||
| name | varchar(255) | No | ||||
| username | varchar(128) | No | ||||
| varchar(128) | No | |||||
| image | varchar(500) | No | ||||
| password | varchar(256) | No | ||||
| role_id | int(11) | No | ||||
| is_active | int(1) | No | ||||
| date_created | int(11) | No | ||||
| alamat | varchar(500) | No | ||||
| kelurahan | varchar(60) | No | ||||
| kecamatan | varchar(60) | No | ||||
| kode_pos | int(10) | No | ||||
| kota | varchar(20) | No | ||||
| jenis_kelamin | varchar(255) | No | ||||
| nomor_handphone_1 | varchar(20) | No | ||||
| nomor_handphone_2 | varchar(20) | No | ||||
| tempat_lahir | varchar(50) | No | ||||
| tanggal_lahir | date | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| role | varchar(128) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |