15 lines
513 B
SQL
15 lines
513 B
SQL
|
|
CREATE TABLE tcg.public.TCG_User_Audit (
|
|
audit_id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY
|
|
, user_id INT NOT NULL
|
|
, CONSTRAINT FK_TCG_User_Audit_user_id
|
|
FOREIGN KEY (user_id)
|
|
REFERENCES tcg.public.TCG_User(user_id)
|
|
, name_field VARCHAR(255) NOT NULL
|
|
, value_prev VARCHAR(500)
|
|
, value_new VARCHAR(500)
|
|
, change_set_id INT NOT NULL
|
|
, CONSTRAINT FK_TCG_User_Audit_change_set_id
|
|
FOREIGN KEY (change_set_id)
|
|
REFERENCES tcg.public.TCG_Change_Set(change_set_id)
|
|
); |