Shard It

Tables (5)

COMMENT (tb_comment)

  • ID (Key) — int — Primary key — NOT NULL
  • POSTER_ID (Key2) — int — Foreign key → POSTER.ID — NOT NULL
  • USER_ID (Key3) — int — Foreign key → POSTER.USER_ID — NOT NULL
  • CONTENT (Field) — varcher(100)
  • CREATE_AT (Field2) — datetime
  • MODIFYED_AT (Field3) — datetime

IMAGE (tb_image)

  • ID (Key) — int — Primary key — NOT NULL
  • POSTER_ID (Key2) — int — Foreign key → POSTER.ID — NOT NULL
  • IMAGE_URL (Field) — varcher(255)
  • CREATE_AT (Field2) — datetime
  • MODIFYED_AT (Field3) — datetime

LIKES (tb_likes)

  • ID (Key) — int — Foreign key → POSTER.ID — NOT NULL
  • USER_ID (Key2) — int — Foreign key → POSTER.USER_ID — NOT NULL
  • CREATE_AT (Field) — datetime
  • MODIFYED_AT (Field2) — datetime

POSTER (tb_poster)

  • ID (Key) — int — Primary key — NOT NULL
  • USER_ID (Key2) — int — Foreign key → USER.ID — NOT NULL
  • CONTENTS (Field) — varcher(255)
  • CREATE_AT (Field2) — datatime
  • MODIFYED_AT (Field3) — datetime

USER (tb_user)

  • ID (Key) — int — Primary key — NOT NULL
  • EMAIL (Field) — varcher(25)
  • PASSWORD (Field2) — varcher(25)
  • NICKNAME (Field3) — varcher(25)
  • PHONE (Field4) — varcher(25)
  • CREATE_AT (Field5) — datetime
  • MODIFYED_AT (Field6) — datetime