restruct cash table

Поиск
Список
Период
Сортировка
От Gerhard Heift
Тема restruct cash table
Дата
Msg-id 20081107084427.GA6158@toaster.kawo1.rwth-aachen.de
обсуждение исходный текст
Список pgsql-general
Hello,

I have a small problem with my table: I have a table for my cash and i
do several actions in it. I receive money in different forms, I expend
money in different forms etc. And do each action I have various foreign
keys. But they are not all in use in every column. I don't know how I
can structure the table better:

CREATE TABLE cash (
  id serial,
  type text NOT NULL,
  account text NOT NULL,
  value numeric(10,2) NOT NULL,
  item text,
  department text,
  person text,
  description text
);

In this table is data like this:

ID | type     | account | value   | item  | department   | client   |
---+----------+---------+---------+-------+--------------+----------+
 1 | sale     | acc_1   |   10,00 | paper | department_1 | NULL     |
 2 | deposit  | acc_1   |   15,00 | NULL  | NULL         | client_1 |
 3 | deposit  | acc_2   |   25,00 | NULL  | NULL         | client_2 |
 4 | transfer | acc_2   |  -15,00 | NULL  | NULL         | NULL     |
 5 | transfer | acc_1   |   15,00 | NULL  | NULL         | NULL     |
 6 | purchase | acc_2   |  -12,00 | NULL  | department_3 | NULL     |
 7 | usage    | NULL    |   -1,00 | page  |              | client_1 |
 8 | usage    | NULL    |    1,00 | page  | department_2 | NULL     |
 9 | usage    | NULL    |   -1,00 | page  | department_1 | NULL     |
10 | usage    | NULL    |    1,00 | page  | department_2 | NULL     |

Is there a better way to store this actions?
(type, account, item, department and client have all its own tables)

Thanks,
  Gerhard

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Berend Tober
Дата:
Сообщение: Re: serial data type usage
Следующее
От: Thomas Kellerer
Дата:
Сообщение: UPDATE tuples with a sub-select