Table address

customer data: addresses

Column NameTypePropertiesDocu
addressidseq64Primary-Key
customeridint32Foreign-Key=customer(customerid)
lastusedint64NULL-able
namestringNULL-able
addr1stringNULL-able
addr2stringNULL-able
citystring:64NULL-able
statestring:32NULL-able
zipcodestring:32NULL-able
countryidstring:16NULL-able Foreign-Key=country(countryid)
isdeletedbooldefault="0"