Week5

Tables (9)

Authoruty (Authority)

  • aurhotityName (Key) — String — Primary key — NOT NULL
  • Field

Comment

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → POST.id — NOT NULL
  • user_id (Key22) — Long — Foreign key → POST.user_id — NOT NULL
  • aurhotityName (Key222) — String — Foreign key → POST.aurhotityName — NOT NULL
  • author (Field2) — String
  • content (Field3) — String

CommentLike

  • Key — String — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → Comment.id — NOT NULL
  • id (Key22) — Long — Foreign key → Comment.id — NOT NULL
  • user_id (Key222) — Long — Foreign key → Comment.user_id — NOT NULL
  • aurhotityName (Key2222) — String — Foreign key → Comment.aurhotityName — NOT NULL
  • count (Field)

Image

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → POST.id — NOT NULL
  • user_id (Key22) — Long — Foreign key → POST.user_id — NOT NULL
  • aurhotityName (Key222) — String — Foreign key → POST.aurhotityName — NOT NULL
  • url (Field) — String

POST

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → USER.user_id — NOT NULL
  • aurhotityName (Key22) — String — Foreign key → USER.aurhotityName — NOT NULL
  • title (Field) — String
  • name (Field2) — String
  • content (Field3) — String

PostLike (Untitled)

  • Key — String — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → POST.id — NOT NULL
  • user_id (Key22) — Long — Foreign key → POST.user_id — NOT NULL
  • aurhotityName (Key222) — String — Foreign key → POST.aurhotityName — NOT NULL
  • count (Field)

SubComment

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → Comment.id — NOT NULL
  • id (Key22) — Long — Foreign key → Comment.id — NOT NULL
  • user_id (Key222) — Long — Foreign key → Comment.user_id — NOT NULL
  • aurhotityName (Key2222) — String — Foreign key → Comment.aurhotityName — NOT NULL
  • author (Field2) — String
  • content (Field) — String

SubCommentLike

  • Key — String — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → SubComment.id — NOT NULL
  • id (Key22) — Long — Foreign key → SubComment.id — NOT NULL
  • id (Key222) — Long — Foreign key → SubComment.id — NOT NULL
  • user_id (Key2222) — Long — Foreign key → SubComment.user_id — NOT NULL
  • aurhotityName (Key22222) — String — Foreign key → SubComment.aurhotityName — NOT NULL
  • count (Field)

USER

  • user_id (Key) — Long — Primary key — NOT NULL
  • aurhotityName (Key2) — String — Foreign key → Authoruty.aurhotityName — NOT NULL
  • nickname (Field1) — String
  • password (Field2) — String
  • activated (Field3) — boolean