marklog

Tables (7)

Notice (NOTICE)

  • id (ID) — INT — Primary key — NOT NULL
  • user (USER_ID) — INT — Foreign key → User.id — NOT NULL
  • content (CONTENT) — TEXT — NOT NULL
  • noticeType (NOTICE_TYPE) — VARCHAR(255) — NOT NULL
  • url (URL) — VARCHAR(255)

Post (POST)

  • id (ID) — INT — Primary key — NOT NULL
  • user (USER_ID) — INT — Foreign key → User.id — NOT NULL
  • summary (SUMMARY) — VARCHAR(30)
  • thumbnail (THUMBNAIL) — VARCHAR(50)
  • title (TITLE) — VARCHAR(50) — NOT NULL
  • content (CONTENT) — TEXT — NOT NULL
  • RegisterDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
  • UpdateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL

PostComment (POST_COMMENT)

  • ID — INT — Primary key — NOT NULL
  • post (POST_ID) — INT — Foreign key → Post.id — NOT NULL
  • Comment (CONTENT) — TEXT — NOT NULL
  • RegisterDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
  • UpdateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL

PostTag (POST_TAG)

  • id (ID) — INT — Foreign key → Post.id — NOT NULL
  • id (ID2) — INT — Foreign key → Tag.id — NOT NULL

Tag (TAG)

  • id (ID) — INT — Primary key — NOT NULL
  • name (NAME) — VARCFHAR — NOT NULL

User (USER)

  • id (ID) — int — Primary key — NOT NULL
  • email (EMAIL) — varchar(30) — NOT NULL
  • name (NAME) — VARCHAR(20) — NOT NULL
  • picture (PICTURE) — VARCHAR(50) — NOT NULL
  • Introduce (INTRODUCE) — VARCHAR(50)
  • title (TITLE) — VARCHAR(50) — NOT NULL
  • registerDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
  • updateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL

postLike (POST_LIKE)

  • post (POST_ID) — INT — Foreign key → Post.id — NOT NULL
  • user (USER_ID) — INT — Foreign key → User.id — NOT NULL