1
Databases / Re: Database standards OR Am I doing this right?
« Last post by paweld on Today at 01:07:33 pm »I use an additional column for this purpose. Example structure:
- CREATE TABLE testtab (
- id NUMERIC IDENTITY(1,1),
- name VARCHAR(50) NOT NULL,
- qty DECIMAL(14,4) NOT NULL,
- price DECIMAL(12,2) NOT NULL,
- description VARCHAR(200) NULL,
- blocked INT NULL, /*is null then if is null then the record is not blocked (not edited) by any user. If it is edited then the field contains the id of the user who is blocking this record*/
- CONSTRAINT pk_testtab PRIMARY KEY clustered (id ASC)
- )