coins delivery_accounts delivery_orders event_users

1
id int id int id int id int
* * *
user_id int name varchar(255) seller_id int user_id int
* * *
amount int user_id int buyer_id int event_id int
*
created_at datetime carrier delivery_accounts_carrier_enum delivery_account_id int joined_at datetime

updated_at datetime token text order_code text completed_at datetime

shop_id varchar(255) status delivery_orders_status_enum created_at datetime

is_default tinyint(1) to_name varchar(255) updated_at datetime

events
created_at datetime to_phone varchar(255)
1
id int
updated_at datetime to_address text
public_id varchar(255) permissions
is_printed tinyint(1)
* 0..1
creator_id int id int
created_date datetime
title text images action varchar(255)
cod_amount int
description text id int subject varchar(255)
weight int
location text url varchar(255) created_at datetime
payment_type_id int
capacity int reference_id int updated_at datetime
total_amount int
coins int reference_type images_reference_type_enum
created_at datetime
end_sign datetime created_at datetime
updated_at datetime role_permissions
start_time datetime updated_at datetime
id int
end_time datetime
*
role_id int
status events_status_enum items
*
ranks 1 permission_id int
created_at datetime id int
id int created_at datetime
updated_at datetime public_id varchar(255)
*
user_id int * updated_at datetime
creator_id int
amount int
name varchar(255)
products order int
description text task_users
id int created_at datetime
price int 1
id int
public_id varchar(255) updated_at datetime
stock int *
* user_id int
seller_id int
status items_status_enum *
task_id int
name varchar(255)
task_submits weight int progress_count int
description text
id int length int assigned_at datetime
price int
* width int
task_user_id int completed_at datetime
category products_category_enum
description text height int created_at datetime
product_status products_product_status_enum
status task_submits_status_enum purchase_limit_per_day int updated_at datetime
post_status products_post_status_enum
submitted_at datetime created_at datetime
created_at datetime
created_at datetime updated_at datetime
updated_at datetime users
updated_at datetime 0..1
1
1 id int

receiver_informations public_id varchar(255)

roles 1
0..1 id int *
transactions role_id int
id int 1 *
id int user_id int avatar_url varchar(255)
name varchar(255)
public_id varchar(255) to_name varchar(255) google_id varchar(255)
description varchar(255)
* to_phone varchar(255)
receiver_information_id int email varchar(255)
created_at datetime
* to_address text
buyer_id int password varchar(255)
updated_at datetime
* to_ward_name varchar(255)
seller_id int username varchar(255)
* to_district_name varchar(255)
item_id int full_name varchar(255)

tasks name varchar(255) to_province_name varchar(255) phone_number varchar(255)

1 account_type receiver_informations_account_type_enum
id int item_snapshot json rank_id int

public_id varchar(255) total_price int is_default tinyint(1) streak int

* created_at datetime
creator_id int quantity int last_completed_task date

title varchar(255) status transactions_status_enum updated_at datetime created_at datetime

description varchar(255) created_at datetime updated_at datetime

coins int updated_at datetime

task_types
difficulty tasks_difficulty_enum
id int
total int *
task_id int
status tasks_status_enum *
type_id int
created_at datetime
created_at datetime
updated_at datetime
updated_at datetime

types
1
id int

type varchar(255)

created_at datetime

updated_at datetime
coins delivery_accounts delivery_orders event_users
1
id int id int id int id int
* * *
user_id int name varchar(255) seller_id int user_id int
delivery_orders_ibfk_3
* * *
amount int user_id int buyer_id int event_id int
*
created_at datetime carrier delivery_accounts_carrier_enum delivery_account_id int joined_at datetime

updated_at datetime token text order_code text completed_at datetime

shop_id varchar(255)event_users_ibfk_2 status delivery_orders_status_enum created_at datetime

is_default tinyint(1) to_name varchar(255) updated_at datetime

events
created_at datetime to_phone varchar(255)
1
id int
updated_at datetime to_address text
public_id varchar(255) permissions
is_printed tinyint(1)
* 0..1
creator_id int id int
created_date datetime
title text images action varchar(255)
cod_amount int
description text id int subject varchar(255)
weight int
location text url varchar(255) created_at datetime
payment_type_id int
capacity int reference_id int updated_at datetime
total_amount int
coins int reference_type images_reference_type_enum role_permissions_ibfk_2
created_at datetime
end_sign datetime created_at datetime
updated_at datetime role_permissions
start_time datetime updated_at datetime
id int
end_time datetime event_users_ibfk_1
*
coins_ibfk_1 delivery_orders_ibfk_1 role_id int
status events_status_enum items delivery_orders_ibfk_2
delivery_accounts_ibfk_1 *
ranks 1 permission_id int
created_at datetime id int
id int created_at datetime
updated_at datetime public_id varchar(255)
*
user_id int * updated_at datetime
creator_id int
amount int
events_ibfk_1 name varchar(255)
products order int
description text task_users
id int created_at datetime
price int 1
id int
public_id varchar(255) updated_at datetime
stock int *
* user_id int
seller_id int
status items_status_enum *
task_id int
name varchar(255) task_submits_ibfk_1
task_submits weight int progress_count int
role_permissions_ibfk_1
description text ranks_ibfk_1
id int length int items_ibfk_1 assigned_at datetime
price int
* width int
task_user_id int completed_at datetime
category products_category_enum task_users_ibfk_1
description text height int created_at datetime
products_ibfk_1
product_status products_product_status_enum
transactions_ibfk_4 purchase_limit_per_day int
status task_submits_status_enum updated_at datetime
post_status products_post_status_enum
submitted_at datetime created_at datetime
created_at datetime
created_at datetime updated_at datetime
updated_at datetime users
updated_at datetime 0..1
1
1 id int
task_users_ibfk_2
receiver_informations public_id varchar(255)
roles 1 receiver_informations_ibfk_1
0..1 id int *
transactions role_id int
id int 1 users_ibfk_1
*
id int user_id int avatar_url varchar(255)
transactions_ibfk_2
name varchar(255) transactions_ibfk_1
to_name transactions_ibfk_3 varchar(255)
public_id varchar(255) google_id varchar(255)
description varchar(255)
* to_phone varchar(255)
receiver_information_id int email varchar(255)
created_at datetime
* to_address text
buyer_id int tasks_ibfk_1 password varchar(255)
updated_at datetime
* to_ward_name varchar(255)
seller_id int username varchar(255)
* to_district_name varchar(255)
item_id int full_name varchar(255)

tasks name varchar(255) to_province_name varchar(255) phone_number varchar(255)

1 account_type receiver_informations_account_type_enum
id int item_snapshot json rank_id int

public_id varchar(255) total_price int is_default tinyint(1) streak int

* created_at datetime
creator_id int quantity int last_completed_task date

title varchar(255) status transactions_status_enum updated_at datetime created_at datetime

task_types_ibfk_1
description varchar(255) created_at datetime updated_at datetime

coins int updated_at datetime

task_types
difficulty tasks_difficulty_enum
id int
total int *
task_id int
status tasks_status_enum *
type_id int
created_at datetime
created_at datetime
updated_at datetime
updated_at datetime

task_types_ibfk_2

types
1
id int

type varchar(255)

created_at datetime

updated_at datetime
Enum delivery_accounts_carrier_enum { Enum products_post_status_enum {
ghn public
ghtk private
grab pending
} rejected
}

Enum delivery_orders_status_enum {
ready_to_pick Enum receiver_informations_account_type_enum {
picking home
money_collect_picking office
picked }
storing
transporting
sorting
delivering Enum task_submits_status_enum {
delivered pending
money_collect_delivering approved
delivery_fail rejected
waiting_to_return }
return
return_transporting
return_sorting
returning Enum tasks_difficulty_enum {
return_fail easy
returned medium
cancel hard
exception event
lost }
damage
}

Enum tasks_status_enum {
public
Enum events_status_enum { private
upcoming }
ongoing
finished
}
Enum transactions_status_enum {
accepted
rejected
Enum images_reference_type_enum { pending
avatar cancelled
taskSubmit }
item
product
event
}

Enum items_status_enum {
available
sold_out
pending
}

Enum products_category_enum {
recycled
handicraft
organic
plants
other
}

Enum products_product_status_enum {
new
used
}