You can view a database structure in the standard ERD (Entity Relation Diagram ... no NOT NULL) A one-to-one relationship is always a solid line due to the unique primary key - foreign key ...