admin
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| username | varchar(30) | No | ||||
| password | varchar(200) | No | ||||
| cookie | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
banner
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| img | varchar(30) | No | ||||
| url | varchar(200) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
categories
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(30) | No | ||||
| icon | varchar(30) | No | ||||
| slug | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
cod
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| regency_id | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
cost_delivery
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| destination | int(11) | No | ||||
| price | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
email_send
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| mail_to | int(11) | No | ||||
| subject | varchar(100) | No | ||||
| message | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
footer
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| page | int(11) | No | ||||
| type | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 9 | A | No |
general
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| app_name | varchar(50) | No | ||||
| slogan | varchar(150) | No | ||||
| navbar_color | varchar(10) | No | ||||
| api_rajaongkir | varchar(70) | No | ||||
| account_gmail | varchar(50) | No | ||||
| pass_gmail | varchar(50) | No | ||||
| varchar(20) | No | |||||
| whatsappv2 | varchar(20) | No | ||||
| email_contact | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
img_product
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_product | int(11) | No | ||||
| img | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 9 | A | No |
invoice
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| invoice_code | varchar(10) | No | ||||
| label | varchar(20) | No | ||||
| name | varchar(50) | No | ||||
| varchar(50) | No | |||||
| telp | varchar(20) | No | ||||
| province | int(11) | No | ||||
| regency | int(11) | No | ||||
| district | varchar(50) | No | ||||
| village | varchar(50) | No | ||||
| zipcode | int(11) | No | ||||
| address | text | No | ||||
| courier | varchar(5) | No | ||||
| courier_service | varchar(70) | No | ||||
| ongkir | varchar(10) | No | ||||
| total_price | int(11) | No | ||||
| total_all | int(11) | No | ||||
| date_input | datetime | No | ||||
| date_limit | datetime | No | ||||
| process | int(11) | No | ||||
| send | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 11 | A | No |
news
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(200) | No | ||||
| banner | varchar(30) | No | ||||
| link | varchar(200) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
package
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(100) | No | ||||
| banner | varchar(30) | No | ||||
| slug | varchar(110) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
package_product
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| package | int(11) | No | ||||
| product | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
pages
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(100) | No | ||||
| content | text | No | ||||
| slug | varchar(40) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
products
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(100) | No | ||||
| price | int(11) | No | ||||
| stock | int(11) | No | ||||
| category | int(11) | No | ||||
| condit | int(11) | No | ||||
| weight | int(11) | No | ||||
| img | varchar(50) | No | ||||
| description | text | No | ||||
| date_submit | datetime | No | ||||
| publish | int(11) | No | ||||
| slug | varchar(100) | No | ||||
| transaction | int(11) | No | ||||
| promo_price | int(11) | No | ||||
| viewer | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 12 | A | No |
rekening
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| rekening | varchar(30) | No | ||||
| name | varchar(50) | No | ||||
| number | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
settings
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| promo | int(11) | No | ||||
| promo_time | varchar(40) | No | ||||
| short_desc | text | No | ||||
| address | varchar(100) | No | ||||
| regency_id | int(11) | No | ||||
| verify | int(11) | No | ||||
| logo | varchar(30) | No | ||||
| favicon | varchar(30) | No | ||||
| ongkir | int(1) | No | ||||
| default_ongkir | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
sosmed
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(20) | No | ||||
| icon | varchar(20) | No | ||||
| link | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No |
subscriber
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| varchar(50) | No | |||||
| date_subs | datetime | No | ||||
| code | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
testimonial
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(30) | No | ||||
| photo | varchar(30) | No | ||||
| content | text | No | ||||
| headline | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
transaction
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_invoice | int(11) | No | ||||
| product_name | varchar(100) | No | ||||
| price | int(11) | No | ||||
| qty | int(11) | No | ||||
| slug | varchar(100) | No | ||||
| ket | varchar(200) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 13 | A | No |