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
Attachment:
signature.asc
Description: Digital signature
