PythonSync - Laravel Schema Designer

p_script

id increments
script_id integer
project_id ^FK integer
object_name string
fields text
soql text
database_id ^FK integer
table_name string
mapping text
batch integer
field_for_update string
isSheduled boolean

p_project

id increments
project_id integer
project_name string
project_org string
crm_username string
crm_password string
crm_domain string
crm_login_uri string
crm_security_token string
database_id ^FK integer

p_database

id increments
project_id ^FK integer
database_id integer
database_type string
db_name string
username text
password text
host string
port string

p_schedule

id increments
script_id integer
cron_expression string
description text
status boolean
last_run_at timestamp

p_log

id increments
script_id ^FK integer
date datetime
processed_count integer
duration integer
message text
status boolean

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01