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

Untitled