Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| genre_id | bpchar | 4 | √ | to_char(nextval('genre_id_seq'::regclass), '"G-"FM00'::text) |
|
|
|||||
| genre | varchar | 16 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| genres_pkey | Primary key | Asc | genre_id |
| genres_genre_key | Must be unique | Asc | genre |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| genres_genre_upper_check | (((genre)::text ~ '^[A-Z]{1}'::text)) |
| genres_genre_id_check | ((genre_id ~ '^G-[0-9]{2}$'::text)) |
Relationships
Close relationships within degrees of separation
