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