# Table: CustomerInvoiceAddress

  • Name: CustomerInvoiceAddress
  • Comment:Lưu thông tin xuất hóa đơn đỏ

# 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 false
Tax Code taxCode 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