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)