staymate

Tables (4)

Board (Untitled2)

  • Board Id (board_id) — INT(1) — Primary key — NOT NULL
  • User Id (user_id) — INT(1) — Foreign key → User.User Id — NOT NULL
  • Board Title (title) — VARCHAR(255)
  • Board Content (content) — TEXT

Comments (Untitled3)

  • Comment Id (comment_id) — INT(1) — Primary key — NOT NULL
  • Board Id (board_id) — INT(1) — Foreign key → Board.Board Id — NOT NULL
  • User Id (user_id) — INT(1) — Foreign key → Board.User Id — NOT NULL
  • Comment Content (content) — TEXT

Enter_Leave_M (Untitled4)

  • Enter Leave Id (checkin_id) — INT(1) — Primary key — NOT NULL
  • User Id (user_id) — INT(1) — Foreign key → User.User Id — NOT NULL
  • Enter Leave Time (check_in_time) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • Enter Leave Late Reason (late_reason) — TEXT
  • Check In (is_checked_in) — TINYINT(1)

User (Untitled)

  • User Id (user_id) — INT(1) — Primary key — NOT NULL
  • User Name (name) — VARCHAR(255)
  • Email (email) — VARCHAR(255)
  • Password (password) — VARCHAR(255)
  • Room Number — VARCHAR(255)
  • Admin (is_admin) — TINYINT(1)