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 по дате отправления: