Laon Task
Tables (4)
tbl_room_booking (Untitled)
- id (Key) — int(10) unsigned — Primary key — NOT NULL
- title (Field4) — varchar(255) — NOT NULL
- description (Field5) — varchar(255)
- date (Field3) — datetime — NOT NULL
- start_time (Field) — datetime — NOT NULL
- end_time (Field2) — datetime — NOT NULL
- created_at (Field6) — datetime — NOT NULL
- updated_at (Field7) — datetime
tbl_room_booking_member (Untitled2)
- booking_id (Key) — int(10) unsigned — Foreign key → tbl_room_booking.id — NOT NULL
- user_id (Primary Key) — int(10) insigned — Foreign key → tbl_user.id — NOT NULL
tbl_team (Team)
- id (Primary Key) — int(10) unsigned — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- head_count (Field2) — int(10) unsigned — NOT NULL
tbl_user (User)
- id (Primary Key) — int(10) insigned — Primary key — NOT NULL
- team_id (fk) — int(10) unsigned — Foreign key → tbl_team.id — NOT NULL
- username (Field) — varchar(50) — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- name (Field5) — varchar(50) — NOT NULL
- email (Field7) — varchar(50) — NOT NULL
- phone (Field8) — varchar(20) — NOT NULL
- profile_img (Field9) — varchar(255)
- created_at (Field3) — datetime — NOT NULL
- updated_at (Field4) — datetime