es - Laravel Schema Designer

admin_users

id increments
name string (255)
password string (255)
email string (255)
session_token string
status integer
login_at datetime
created_at datetime
updated_at datetime
mark string (1024)
role_id ^FK integer

organizations

id increments
name string
logo_url string
image_url string
home_page string
telephone string (50)
email string
status integer
contact string
province_id integer
city_id integer
region_id integer
address string
zipcode string
longitude string
latitude string
mark string
created_at datetime
updated_at datetime

courses

id increments
org_id ^FK integer
logo_url string
image_url string
contact string
telephone string
province_id integer
subject string
city_id integer
region_id integer
address string
zipcode string
longitude string
latitude string
created_at datetime
updated_at datetime
mark string
status integer

campaigns

id increments
org_id ^FK integer
subject string
logo_url string
image_url string
contact string
address string
telephone string
province_id integer
city_id integer
region_id integer
zipcode string
longitude string
latitude string
created_at datetime
updated_at datetime
mark string
status integer

ranks

id increments
member_id integer
object_id integer
obj_type integer
rank_value string
created_at datetime

comments

id increments
member_id integer
context string
object_id integer
obj_type integer
created_at datetime
status integer

order_master

id increments
code string
member_id integer
course_id integer
type integer
price float
pay_type integer
pay_date datetime
status integer
created_at timestamp
updated_at timestamp
object_id integer
obj_type integer
mark string
org_id string

member_grade

id increments
name string
level string

member

id increments
customer_id integer
grade_id string

classrooms

id increments
name string
org_id ^FK integer
sort_id integer
mark string (1024)
timestamps timestamps

roles

id increments
name string
org_id ^FK integer
sort_id integer
mark string (1024)

permissions

id increments
name string
desc string

users

id increments
name string
password string
email string (255)
mobile string (255)
token string (255)
status integer
login_at datetime
created_at string
updated_at datetime
role_id ^FK integer
mark string (1024)

customers

id increments
name string
sex integer
email string
mobile string
avatar string
birthday datetime
created_at string
session_token string
updated_at string
province_id integer
city_id integer
region_id integer
address string
zipcode string
longitude string
latitude string
mark string

organization_member

id increments
member_id integer
organization_id integer

member_point

id increments
member_id integer
point integer

point_transaction

id increments
action string
point integer
member_id integer
before integer
final integer

footer

id increments

permission_role

permission_id integer
role_id integer

contract

id increments
org_id integer
context string
start_date datetime
end_date datetime
attach_file string
status string
created_at timestamp
updated_at timestamp
mark string

order_refunds

id increments
order_code string
apply_userid integer
apply_user_type integer
operator_userid string
operator_type integer
price float
status integer
created_at datetime
updated_at datetime
mark string

contract_detail

id increments
timestamps timestamps
contract_id integer
operator_userid integer
status integer
mark text

course_breakdown

id increments
course_id ^FK integer
name string
duration_time float
classroom_id string
price float
sort_id integer
mark text
pay_type integer

course_series

id increments
course_id ^FK integer
series_id integer

series

id increments
display_name string
sort_id integer
mark string

organ_label

id increments
org_id ^FK integer
label ^FK integer

campaign_series

id increments
campaign_id ^FK integer
series_id ^FK integer

system_log

id increments
context text
created_at datetime
type integer
userid integer
user_type integer

point_rules

id increments
name string
action string
point_value integer
mark text

course_schedules

id increments
org_id integer
course_id string
admin_userid integer
classroom_id integer
schedule_date datetime
start_time time
end_time time

course_point_rules

id increments
course_id integer
rule_id integer

content_info

id increments
object_id integer
obj_type integer
content text
created_at datetime
updated_at datetime
publish_date datetime
operator_userid integer
operator_type integer
short_desc string
long_desc string (1024)

order_detail

id increments
master_code string

admin_user_roles

id increments
admin_userid integer
role_id integer

user_roles

id increments
userid integer
role_id integer

customer_roles

id increments
customer_id integer
role_id integer

execute_logs

id increments

organ_top

id increments
org_id integer
sort_id integer

course_top

id increments
course_id integer
sort_id integer

event_top

id increments
timestamps timestamps

es_event

id increments
timestamps timestamps

es_adlist

id increments

ad_type

id increments
timestamps timestamps