Schedules

Tables (3)

Comment (comments)

  • Comment_id (comment_id) — bigint(10) — Primary key — NOT NULL
  • Contents (contents) — VARCHAR(100)
  • Comments User (comments_user) — VARCHAR(20)
  • Create Date (created_at) — TIMESTAMP
  • Update Date (updated_at) — TIMESTAMP
  • Schedule_id (schedule_id) — bigint(10) — Foreign key → Schedules.Schedule_id — NOT NULL

Schedules (schedules)

  • Schedule_id (schedule_id) — bigint(10) — Primary key — NOT NULL
  • User Name (username) — VARCHAR(20)
  • Title (title) — VARCHAR(50)
  • Contents (contents) — VARCHAR(100)
  • Create Date (created_at) — TIMESTAMP
  • Update Date (updated_at) — TIMESTAMP
  • User_id (user_id) — bigint(10) — Foreign key → Users.User_id — NOT NULL

Users (users)

  • User_id (user_id) — bigint(10) — Primary key — NOT NULL
  • User Name (username) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Create Date (created_at) — TIMESTAMP
  • Update Date (updated_at) — TIMESTAMP
  • Schedule_id (schedule_id) — bigint(10) — Foreign key → Schedules.Schedule_id — NOT NULL