Home
rof_db
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
suppliers
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
stocks
id
increments
code
string
product_id
FK
integer
supplier_id
FK
integer
branch_id
FK
integer
qty
integer
cost
decimal
(10,3)
receive_no
datetime
location
string
warning_flag
integer
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
products
id
increments
code
string
name_en
string
name_th
string
price
decimal
(10,3)
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
category_id
FK
integer
standard_id
FK
integer
source_id
FK
integer
unit_id
FK
integer
product_attribute
id
increments
code
string
product_id
FK
integer
attribute_id
FK
integer
value_en
text
value_th
text
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
attributes
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
categories
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
cart_items
id
increments
code
string
cart_id
FK
bigInteger
product_id
FK
integer
qty
integer
price
decimal
(10,3)
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
orders
id
bigIncrements
code
string
user_id
FK
bigInteger
cart_id
FK
bigInteger
user_address_id
FK
bigInteger
payment_type_id
FK
integer
total
decimal
(10,3)
status
tinyInteger
discount
decimal
(10,3)
discount_code
text
earn_reward_point
integer
use_reward_point
integer
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
standards
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
sources
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
units
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
images
id
increments
code
string
product_id
FK
integer
attachment_id
FK
integer
parrent
integer
title
string
description
text
width
integer
height
integer
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
attachments
id
increments
code
string
name_en
string
name_th
string
size
integer
mime
string
path
text
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
users
id
bigIncrements
username
string
(30)
email
string
(100)
password
string
(100)
register_ip
string
(15)
forget_token
string
(100)
active_token
string
(100)
timestamps
timestamps
mobile
string
is_active
boolean
is_deleted
boolean
roles
id
increments
name
string
login_attempts
id
increments
user_id
FK
bigInteger
login_ip
ipAddress
login_time
timestamps
permission_role
permission_id
FK
integer
role_id
FK
integer
permissions
id
increments
slug
string
(100)
role_user
role_id
FK
integer
user_id
FK
bigInteger
rewiews
id
increments
code
string
product_id
FK
integer
user_id
FK
bigInteger
rating
double
comment
text
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
cart
id
bigIncrements
session
text
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
user_adress
id
bigIncrements
code
string
user_id
FK
bigInteger
addr
text
street
string
state
string
city
string
country
string
zipcode
string
latitude
string
longitude
string
remark
text
is_default
tinyInteger
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
branchs
id
increments
code
string
name_en
string
name_th
string
description
text
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
user_reward_point
id
increments
code
string
order_id
FK
bigInteger
user_id
FK
bigInteger
reward_point
double
(8,3)
reward_type
tinyInteger
operation_type
tinyInteger
expire_on
datetime
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
user_detail
id
increments
user_id
FK
bigInteger
title_id
FK
integer
firstname
string
lastname
string
status
tinyInteger
gender
tinyInteger
birthdate
date
reward_point
integer
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
titles
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
payment_type
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
payments
id
increments
code
string
name_en
string
name_th
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
user_payment
id
increments
code
string
user_id
FK
bigInteger
payment_type_id
FK
integer
payment_id
FK
integer
payment_number
string
status
tinyInteger
is_deleted
softDeletes
timestamps
timestamps
created_by
string
updated_by
string
deleted_by
string
is_default
tinyInteger
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01