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