> > trx_date | trx_time | descriptions |
> > payment_method | debet | credit | creator
> > ------------+----------+--------------------------------------+----
> >--------- ---+-------+----------+---------
> > 2003-10-09 | 21:55:02 | Resto Biling : 13,800, Paid : 10,000 |
> > Visa
> >
> > | 3800 | | middink
> >
> > 2003-10-16 | 03:28:30 | Payment - Thank You |
> > Visa
> >
> > | | 40000.00 | middink
> >
> > 2003-10-08 | 18:17:40 | Payment - Thank You |
> > Cash
> >
> > | | 50000.00
>
> The id field only keeps the transactions in the correct order so you
> can sum the previous transactions. You can do the same thing with
> your date and time fields (though using a single datetime field would
> be easier). A caution, though: you will have trouble if two
> transactions share the same date and time.
if i would like to pleaced ID(Virtual ID) for example number of record for
each record, how to ?
num_rec | trx_date | trx_time | credit |
descriptions | payment_method | debet
---------+------------+----------+----------+-------------------------------
-------------------------+----------------+-------
1 | 2003-10-09 | 21:55:02 | | Resto Biling : Rp.
13,800, Paid : Rp. 10,000 | Visa | 3800
2 | 2003-10-16 | 03:28:30 | 40000.00 | Payment
| Visa |
3 | 2003-10-08 | 18:17:40 | 50000.00 | Payment
| Cash |
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
