FK_Blog_category_id_Category_id
FK_Blog_Tag_blog_id_Blog_id
FK_Blog_Tag_tag_id_Tag_id
expected_birth_date
DATE
NN
FK_Child_user_id_User_user_id
FK_Comment_post_id_Post_id
FK_Comment_user_id_User_id
Trial
media_url
VARCHAR(1000)
NN
FK_Media_visit_record_id_Visit_Record_id
membership_id
CHAR(36)
NN
description
VARCHAR(255)
NN
measurement_unit
VARCHAR(255)
NN
upperbound_msg
CHAR(255)
NN
lowerbound_msg
CHAR(255)
NN
Trial
payment_history_id
CHAR(36)
NN
membership_id
CHAR(36)
NN
payos_order_code
CHAR(13)
NN
FK_Payment_History_membership_id_Membership_id
FK_Payment_History_user_id_User_id
FK_Reaction_post_id_Post_id
FK_Reaction_user_id_User_id
FK_Reminder_user_id_User_id
FK_Reminder_visit_record_id_Visit_Record_id
FK_Standard_metric_id_Metric_id
refresh_token
VARCHAR(255)
NN
visit_record_id
CHAR(36)
NN
next_visit_doctor_date
DATETIME
visit_doctor_date
DATETIME
NN
doctor_name
VARCHAR(510)
NN
FK_Visit_Record_hospital_id_Hospital_id
FK_Visit_Record_user_id_Child_id
visit_record_metric_id
CHAR(36)
NN
visit_record_id
CHAR(36)
NN
FK_Visit_Record_Metric_metric_id_Metric_id
FK_Visit_Record_Metric_tag_id_Tag_id
FK_Visit_Record_Metric_visit_record_id_Visit_Record_id
Documentation for project Mother Journal
Report
Generated
4/2/2025 | 11:03:21 AM
tables
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
blog_id
CHAR
36
Yes
Yes
title
VARCHAR
255
Yes
author
VARCHAR
255
Yes
summary
VARCHAR
255
Yes
created_at
DATE
Yes
updated_at
DATE
Yes
content
MEDIUMTEXT
Yes
category_id
CHAR
36
Yes
blog_cover
LONGTEXT
Yes
Indexes
FK_Blog_category_id_Category_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
blog_tag_id
CHAR
36
Yes
Yes
blog_id
CHAR
36
Yes
tag_id
CHAR
36
Yes
Indexes
FK_Blog_Tag_blog_id_Blog_id
FK_Blog_Tag_tag_id_Tag_id
Keys
PRIMARY
Column in PRIMARY
blog_tag_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
category_id
CHAR
36
Yes
Yes
title
VARCHAR
1000
Yes
status
INT
Yes
Keys
PRIMARY
Column in PRIMARY
category_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
child_id
CHAR
36
Yes
Yes
expected_birth_date
DATE
Yes
name
VARCHAR
100
Yes
gender
INT
user_id
CHAR
36
Yes
Indexes
FK_Child_user_id_User_user_id
Keys
PRIMARY
Column in PRIMARY
child_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
comment_id
CHAR
36
Yes
Yes
content
VARCHAR
1000
Yes
post_id
CHAR
36
Yes
user_id
CHAR
36
Yes
created_at
DATETIME
updated_at
DATETIME
Indexes
FK_Comment_post_id_Post_id
FK_Comment_user_id_User_id
Keys
PRIMARY
Column in PRIMARY
comment_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
hospital_id
CHAR
36
Yes
Yes
city
VARCHAR
255
Yes
name
VARCHAR
255
Yes
Keys
PRIMARY
Column in PRIMARY
hospital_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
media_id
CHAR
36
Yes
Yes
media_url
VARCHAR
1000
Yes
created_at
DATE
Yes
visit_record_id
CHAR
36
post_id
CHAR
36
Indexes
FK_Media_post_id_Post_id
FK_Media_visit_record_id_Visit_Record_id
Column name
visit_record_id
Keys
PRIMARY
Column in PRIMARY
media_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
membership_id
CHAR
36
Yes
Yes
title
VARCHAR
255
Yes
description
VARCHAR
255
Yes
price
FLOAT
Yes
created_at
DATE
Yes
updated_at
DATE
Yes
status
INT
Yes
duration_days
INT
Yes
Keys
PRIMARY
Column in PRIMARY
membership_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
metric_id
CHAR
36
Yes
Yes
title
VARCHAR
255
Yes
measurement_unit
VARCHAR
255
Yes
status
INT
Yes
required
TINYINT
1
Yes
upperbound_msg
CHAR
255
Yes
lowerbound_msg
CHAR
255
Yes
tag_id
CHAR
36
Indexes
FK_Metric_tag_id_Tag_id
Keys
PRIMARY
Column in PRIMARY
metric_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
note_id
CHAR
36
Yes
Yes
title
VARCHAR
255
Yes
content
VARCHAR
510
Yes
date
DATETIME
Yes
status
INT
Yes
user_id
CHAR
36
Yes
Indexes
FK_Note_user_id_User_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
payment_history_id
CHAR
36
Yes
Yes
user_id
CHAR
36
Yes
membership_id
CHAR
36
Yes
created_at
DATETIME
Yes
value
DOUBLE
Yes
status
INT
Yes
payment_method
INT
Yes
expired_at
DATETIME
payos_order_code
CHAR
13
Yes
Indexes
FK_Payment_History_membership_id_Membership_id
FK_Payment_History_user_id_User_id
Keys
PRIMARY
Column in PRIMARY
payment_history_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
post_id
CHAR
36
Yes
Yes
content
TEXT
Yes
user_id
CHAR
36
Yes
created_at
DATETIME
updated_at
DATETIME
Indexes
FK_Post_user_id_User_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
reaction_id
CHAR
36
Yes
Yes
user_id
CHAR
36
Yes
post_id
CHAR
36
Yes
Indexes
FK_Reaction_post_id_Post_id
FK_Reaction_user_id_User_id
Keys
PRIMARY
Column in PRIMARY
reaction_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
reminder_id
CHAR
36
Yes
Yes
type
INT
Yes
title
VARCHAR
255
Yes
content
VARCHAR
255
Yes
remind_date
DATE
Yes
status
INT
Yes
user_id
CHAR
36
Yes
visit_record_id
CHAR
36
color
CHAR
6
Indexes
FK_Reminder_user_id_User_id
FK_Reminder_visit_record_id_Visit_Record_id
Column name
visit_record_id
Keys
PRIMARY
Column in PRIMARY
reminder_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
standard_id
CHAR
36
Yes
Yes
week
INT
Yes
upperbound
FLOAT
Yes
lowerbound
FLOAT
Yes
metric_id
CHAR
36
Yes
who_standard_value
FLOAT
Indexes
FK_Standard_metric_id_Metric_id
Keys
PRIMARY
Column in PRIMARY
standard_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
tag_id
CHAR
36
Yes
Yes
title
VARCHAR
255
Yes
status
INT
Yes
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
token_id
CHAR
36
Yes
Yes
user_id
CHAR
36
Yes
refresh_token
VARCHAR
255
Yes
created_at
DATE
Yes
updated_at
DATE
Yes
Indexes
FK_Token_user_id_User_id
Keys
PRIMARY
Column in PRIMARY
token_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
user_id
CHAR
36
Yes
Yes
avatar
LONGTEXT
email
VARCHAR
255
Yes
password
VARCHAR
255
Yes
name
VARCHAR
255
Yes
phone
VARCHAR
255
Yes
province
VARCHAR
255
Yes
district
VARCHAR
255
Yes
ward
VARCHAR
255
Yes
address
VARCHAR
255
Yes
status
INT
Yes
created_at
DATE
Yes
updated_at
DATE
Yes
role
INT
Yes
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
visit_record_id
CHAR
36
Yes
Yes
next_visit_doctor_date
DATETIME
visit_doctor_date
DATETIME
Yes
doctor_name
VARCHAR
510
Yes
hospital_id
CHAR
36
Yes
created_at
DATETIME
Yes
child_id
CHAR
36
Yes
Indexes
FK_Visit_Record_hospital_id_Hospital_id
FK_Visit_Record_user_id_Child_id
Keys
PRIMARY
Column in PRIMARY
visit_record_id
Properties
Database
swp_pregnancy
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_0900_ai_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
visit_record_metric_id
CHAR
36
Yes
Yes
tag_id
CHAR
36
value
FLOAT
Yes
value_extended
INT
metric_id
CHAR
36
Yes
visit_record_id
CHAR
36
Yes
updated_at
DATE
Yes
created_at
DATE
Yes
Indexes
FK_Visit_Record_Metric_metric_id_Metric_id
FK_Visit_Record_Metric_tag_id_Tag_id
FK_Visit_Record_Metric_visit_record_id_Visit_Record_id
Column name
visit_record_id
Keys
PRIMARY
Column in PRIMARY
visit_record_metric_id
relationships
Name
FK_Blog_category_id_Category_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in category
Column in blog
PRIMARY
category_id
category_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Blog_Tag_tag_id_Tag_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in tag
Column in blog_tag
PRIMARY
tag_id
tag_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Blog_Tag_blog_id_Blog_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in blog
Column in blog_tag
PRIMARY
blog_id
blog_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Child_user_id_User_user_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in child
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Comment_post_id_Post_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in post
Column in comment
PRIMARY
post_id
post_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Comment_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in comment
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Media_post_id_Post_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Optional
Key and columns
Key name
Column in post
Column in media
PRIMARY
post_id
post_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Media_visit_record_id_Visit_Record_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Optional
Key and columns
Key name
Column in visit_record
Column in media
PRIMARY
visit_record_id
visit_record_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Metric_tag_id_Tag_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Optional
Key and columns
Key name
Column in tag
Column in metric
PRIMARY
tag_id
tag_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Note_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in note
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Payment_History_membership_id_Membership_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in membership
Column in payment_history
PRIMARY
membership_id
membership_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Payment_History_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in payment_history
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Post_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in post
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Reaction_post_id_Post_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in post
Column in reaction
PRIMARY
post_id
post_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Reaction_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in reaction
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Reminder_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in reminder
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Reminder_visit_record_id_Visit_Record_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Optional
Key and columns
Key name
Column in visit_record
Column in reminder
PRIMARY
visit_record_id
visit_record_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Standard_metric_id_Metric_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metric
Column in standard
PRIMARY
metric_id
metric_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Token_user_id_User_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in user
Column in token
PRIMARY
user_id
user_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Visit_Record_hospital_id_Hospital_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in hospital
Column in visit_record
PRIMARY
hospital_id
hospital_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Visit_Record_child_id_Child_child_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in child
Column in visit_record
PRIMARY
child_id
child_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Visit_Record_Metric_visit_record_id_Visit_Record_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in visit_record
Column in visit_record_metric
PRIMARY
visit_record_id
visit_record_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Visit_Record_Metric_metric_id_Metric_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Key and columns
Key name
Column in metric
Column in visit_record_metric
PRIMARY
metric_id
metric_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
Name
FK_Visit_Record_Metric_tag_id_Tag_id
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Optional
Key and columns
Key name
Column in tag
Column in visit_record_metric
PRIMARY
tag_id
tag_id
Properties
Rerefential integrity - parent delete
No action
Referential integrity - parent update
No action
