dd
Tables (11)
Address
- addressId (Key) — int — Primary key — NOT NULL
- street (Field) — varchar
- city (Field2) — varchar
- zipcode (Field3) — varchar
Author
- authorId (Key) — int — Primary key — NOT NULL
- authorName (Field) — varchar
Author (Author2)
- authorId (Key) — int — Primary key — NOT NULL
- authorName (Field) — varchar
Book
- bookId (Key) — int — Primary key — NOT NULL
- authorId (Key2) — int — Foreign key → Author.authorId — NOT NULL
- Field — varchar
Book (Book2)
- bookId (Key) — int — Primary key — NOT NULL
- bookName (Field) — varchar
BookAuthorJoin
- bookId (Key) — int — Foreign key → Book.bookId — NOT NULL
- authorId (Key2) — int — Foreign key → Author.authorId — NOT NULL
Comment
- idComment (Key) — int — Primary key — NOT NULL
POSTCOMMENTS (_)
- POST_ID (Key) — int — Foreign key → Post.idPost — NOT NULL
- COMMENT_ID (Key2) — int — Foreign key → Comment.idComment — NOT NULL
Person
- personId (Key) — int — Primary key — NOT NULL
- personName (Field1) — varchar
- addressId (Key2) — int — Foreign key → Address.addressId — NOT NULL
Post
- idPost (Key) — int — Primary key — NOT NULL