su_orlov


Columns

Column Type Size Nulls Auto Default Children Parents Comments
handelses_id int8 19 null
su_handelser.handelses_id su_orlov_fk1 R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
ind_hand_ref_id int8 19 √ null
su_handelser.handelses_id su_orlov_fk2 R
orlov_hand_ref_id int8 19 √ null
su_handelser.handelses_id su_orlov_fk3 R
orlov_id numeric 0 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null

Indexes

Constraint Name Type Sort Column(s)
su_orlov_pk Primary key Asc handelses_id
su_orlov_fk2_i Performance Asc ind_hand_ref_id
su_orlov_fk3_i Performance Asc orlov_hand_ref_id

Check Constraints

Constraint Name Constraint
su_orlov_check (('IND_HAND_REF_ID' IS NOT NULL))
su_orlov_check1 (('OPDINIT' IS NOT NULL))
su_orlov_check5 (('ORLOV_ID' IS NOT NULL))
su_orlov_check4 (('ORLOV_HAND_REF_ID' IS NOT NULL))
su_orlov_check7 (('STARTDATO' IS NOT NULL))
su_orlov_check2 (('OPDMOD' IS NOT NULL))
su_orlov_check3 (('OPDTID' IS NOT NULL))
su_orlov_check6 (('SLUTDATO' IS NOT NULL))

Relationships

Close relationships within degrees of separation