DB table for addresses

[pooja]

Hi,

I would like to know where is the billing address gets stored. I know that shipping address gets stored in the "address_book" table. And also, Is there a way to know which table serves what purpose as there is no description added in the table definitions. Sometimes, its a bit confusing as there are too many tables.

I also checked that there are no foreign constraints. Is there any specific reason behind it?

Thanks in advance.

[pooja]

I want to add a validation for postal codes. Currently we are restricting the delivery of our product in certain areas only. Hence I need to check whether the entered post code in shipping address is one among the covered areas only.

Do I need to add a custom table for that? How custom tables are accessed as the database layer is abstracted in Konakart.

Thank you.

[pooja]

Can anyone please help me? I am stuck .

Thanks.

[Expert Review]

U have access Custom table

_{<%@page import="com.konakart.db.KKBasePeer"%>
List<Record> result= KKBasePeer.executeQuery("Select * from customtable");
for (Record rs: result) {
   int x= rs.getValue("colName1").asInt();
   String y= rs.getValue("colName2").asString();
                  
}}

[pooja]

Thanks a lot for your reply.