Table: CustomerAddress
Name
: CustomerAddress Comment
:Lưu địa chỉ của khách hàng ei
Primary Key
Columns
: Id Cluster
: false
Indexes[]
Columns | Cluster | Unique |
id | | true |
Foreign Keys[]
Columns | Ref Table | Ref Columns | Options |
createdBy | Users | id | |
updatedBy | Users | id | |
Relationships
Columns | Ref Table | Ref Columns | Options |
Columns[]
Label | Name | Type | Nullable | Default | Comment |
Id | id | int auto_increment | false | | |
Customer | customerId | int | false | | |
Company | companyName | text | false | | |
Receiver | receiverNa | text | false | | |
Email | email | text | true | null | |
Phone | phone | text | true | null | |
Province | province | text | true | null | |
District | district | text | true | null | |
Ward | ward | text | true | null | |
Address | address | varchar | false | null | |
Created By | createdBy | int | false | | |
Updated By | updatedBy | int | true | null | |
Created At | createdAt | datetime | true | | |
Updated At | updatedAt | datetime | true | | |
Deleted | deleted | tinyint(1) | false | 0 | |
Is Default | isDefault | tinyint(1) | true | 0 | |