Taxi

Tables (5)

Chat Message (chat message)

  • Chat ID (chat_id) — BIGINT — Primary key — NOT NULL
  • Chat Create Date (chat_create_date) — TIMESTAMP
  • Message (message) — VARCHAR(255)
  • Nickname (nickname) — VARCHAR(255)
  • ID — BIGINT — Foreign key → Taxi Chat.ID — NOT NULL
  • ID (ID2) — BIGINT — Foreign key → User.ID — NOT NULL

Taxi Chat (taxi chat)

  • ID — BIGINT — Primary key — NOT NULL
  • Room ID (room_id) — BIGINT
  • Chat ID (chat_id) — VARCHAR(255)
  • Room ID (ID2) — BIGINT — Foreign key → Taxi Post.Room ID — NOT NULL

Taxi Post (taxi post)

  • Room ID (ID) — BIGINT — Primary key — NOT NULL
  • Title (title) — VARCHAR(255)
  • Departuer (departure) — VARCHAR(255)
  • Destination (destination) — VARCHAR(255)
  • Departure Time (departure time) — TIMESTAMP
  • Number Of Recruitment (number_of_recruitment) — BIGINT
  • Number Of Participant (number_of_participant) — BIGINT
  • Post Create Date (post_create_date) — TIMESTAMP
  • Status (status) — VARCHAR(255)
  • Nickname (nickname) — VARCHAR(255)
  • ID (ID2) — BIGINT — Foreign key → User.ID — NOT NULL

User (user)

  • ID — BIGINT — Primary key — NOT NULL
  • Name (user_name) — VARCHAR(255)
  • Student ID (student_id) — VARCHAR(255)
  • Phone Number (phone_number) — BIGINT
  • Email Address (email) — VARCHAR(255)
  • Nickname (nickname) — VARCHAR(255)
  • Level (level) — BIGINT
  • Number Of Uses (number_of_uses) — BIGINT
  • User Create Date (user_create_date) — TIMESTAMP

User Posts (user posts)

  • ID — BIGINT — Primary key — NOT NULL
  • Post Create Date (post_create_date) — TIMESTAMP
  • Status (status) — BIGINT
  • Nickname (nickname) — VARCHAR(255)
  • ID (ID2) — BIGINT — Foreign key → User.ID — NOT NULL