randomname2 - Laravel Schema Designer

user

id increments
email string
password string
is_artist tinyInteger
is_admin tinyInteger
confirmed tinyInteger
confirmation_code string
fb_id string
remember_token string (100)
updated_at timestamp
created_at timestamp

profession

id increments
title string
lang_code string

association

id increments
association string
lang_code string

profile

user_id increments
language integer
slug string
image_id integer
firstname string
lastname string
email string
dob date
phone string
address string
city string
zip string
country string (45)
IBAN string
SWIFT string
about_user_langcode string
is_associated integer
association string
kuvataiteilijamatrikkeli tinyInteger
is_mailsubscribed string
profile_completed string
commission double
created_at timestamp
updated_at timestamp

artist_away

user_id increments
awayDate date
returnDate date
created_at timestamp
updated_at timestamp

curriculum

user_id increments
name string
ext string
original_filename string (45)

profile_evaluation

user_id increments
in_evaluation tinyInteger
status string
created_at timestamp
updated_at timestamp

profession_user

user_id integer
profession_id integer

association_user

user_id integer
association_id integer

follower_id integer
followed_id integer

image

id increments
image_name string
thumb_name string
mime string
bw tinyInteger

artwork

id increments
user_id integer
category_id integer
slug string
price_range_id integer
price decimal (9,3)
vat integer
full_price decimal (9,3)
is_discounted tinyInteger
discounted_by tinyInteger
discount_percent integer
views integer
favorites integer
is_active tinyInteger
for_sale tinyInteger
size_range_id integer
orientation integer
depth double
width double
height double
weight double
created_year integer
copyright_owner tinyInteger
is_hidden tinyInteger
created_at timestamp
updated_at timestamp
published_at timestamp
translation_description_code string
translation_title_code string
shipping tinyInteger

favorites

user_id integer
artwork_id integer

category

id increments
name string
parent_id integer
root_category_id integer
lang_code string

translation

id increments
code string
lang_id integer
translation text

language

id increments
code string
name string
is_active tinyInteger

sold_giftcard

id increments
giftcard_Id integer
payment_id integer
code string (10)
transaction_id string (50)

sold_artwork

id increments
payment_id integer
artwork_id integer
delivery_status string
pick_up_address string
pick_up_city string
pick_up_zip string
tracking_id string
pdf_id string
pick_up_date date
delivery_date date
created_at timestamp
updated_at timestamp

image_properties

image_id integer
group_0 integer
group_1 integer
group_2 integer
group_3 integer
group_4 integer
hierarchy_color_0 double (4,2)
hierarchy_color_1 double (4,2)
hierarchy_color_2 double (4,2)
hierarchy_color_3 double (4,2)
hierarchy_color_4 double (4,2)
bw tinyInteger
curate tinyInteger

color_palette

id increments
HEX string
color_group integer
slug string
name string

artwork_keyword

artwork_id integer
keyword_id integer

artwork_theme

artwork_id integer
theme_id bigInteger

size_range

id increments
name string
lang_code string

keywords

id increments
en string
fi string
sv string
curate tinyInteger
created_at timestamp
updated_at timestamp

theme

id increments
name string
lang_code string

artwork_image

artwork_id integer
image_id integer
is_primary tinyInteger

password_resets

email string
token string
created_at timestamp

price_range

id increments
name string
min double
max double
lang_code string

billing_profile

id increments
user_id integer
country string
firstname string
lastname string
company string
companyId string
address string
lang_id integer
address_additional string
city string
email string
phone string
zip string
created_at timestamp
updated_at timestamp

payment

id increments
shipping_profile_id integer
billing_profile_id integer
items string
amount string
discount_code string
discount_percent string
giftcard_code string
giftcard_amount integer
currency string
method string
status_code string
status string
processor string
returnData text
created_at timestamp
updated_at timestamp

giftcard

id increments
billingProfileId integer
name string
price double
user_id integer
code string (6)
is_active tinyInteger
valid_till date
created_at timestamp
updated_at timestamp
to_print tinyInteger

shipping_profile

id increments
country string
firstname string
lastname string
company string
address string
address_additional string
city string
email string
phone string
zip string
order_notes string
created_at timestamp
updated_at timestamp

discount_coupon

id increments
code string
percent double
valid_till date
is_active tinyInteger
created_at timestamp
updated_at timestamp

log

user_id integer
edited_by integer
action string
timestamp timestamp

search_log

id increments
query string
created_at timestamp