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