Gachicar
Gatchicam erd
Tables (23)
Untitled (log_message_view)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (room_message_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (log_location_search)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (name) — VARCHAR(36)
- Field (x) — DECIMAL(7,4) — NOT NULL
- Field (y) — DECIMAL(7,4) — NOT NULL
- Field (favorite) — TINYINT(1) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (deletedate) — DATETIME
Untitled (file)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (filepath_id) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (parentid) — VARCHAR(36) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (path) — VARCHAR(255) — NOT NULL
- Field (name_original) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255)
- Field (size) — INT(11)
- Field (createdate) — DATETIME — NOT NULL
Untitled (university_verification)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id
- Key (university_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (email) — VARCHAR(255)
- Field (file_idcard) — VARCHAR(255)
- Field (file_university_doc) — VARCHAR(255)
- Field (status) — INT(7) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (confirmdate) — DATETIME
Untitled (report)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (target_user_id) — VARCHAR(36) — NOT NULL
- Field (target_id) — VARCHAR(36) — NOT NULL
- Field (reason) — INT(7) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (reason_text) — MEDIUMTEXT
- Field (handler_id) — VARCHAR(36)
- Field (status) — INT(7) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (handle_method) — INT(7)
- Field (handledate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (reply)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (board_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (title) — VARCHAR(255) — NOT NULL
- Field (text) — MEDIUMTEXT — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (modifydate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (like_board)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (board_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
Untitled (comment)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (board_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
Untitled (image_board)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (board_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (path) — VARCHAR(255) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (deletedate) — DATETIME
Untitled (car_licence)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (car_number) — VARCHAR(255) — NOT NULL
- Field (model) — VARCHAR(255) — NOT NULL
- Field (color) — VARCHAR(36) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (driver_licence)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (licence_number) — VARCHAR(255) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (birthday) — VARCHAR(255) — NOT NULL
- Field (licence_duedate) — DATETIME — NOT NULL
- Field (cvc) — VARCHAR(255) — NOT NULL
- Field (image) — VARCHAR(255) — NOT NULL
- Field (status) — INT(7) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (confirmdate) — DATETIME
Untitled (board)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (university_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (title) — VARCHAR(255) — NOT NULL
- Field (text) — MEDIUMTEXT — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (modifydate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (room_message)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (room_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (text) — MEDIUMTEXT
- Field (senddate) — DATETIME — NOT NULL
Untitled (user_score)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (target_id) — VARCHAR(36) — NOT NULL
- Field (score) — INT(10) — NOT NULL
- Field (eventdate) — DATETIME — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (code)
- Key (code) — INT(7) — Primary key — NOT NULL
- Key (code_master) — INT(4) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (data) — VARCHAR(255)
- Field (createdate) — DATETIME — NOT NULL
Untitled (code_master)
- Key (code_master) — INT(4) — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (use) — TINYINT(1) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (participant)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (room_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (baggage) — INT(3) — NOT NULL
- Field (joindate) — DATETIME — NOT NULL
- Field (withdrawdate) — DATETIME
Untitled (location)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (x) — DECIMAL(7,3) — NOT NULL
- Field (y) — DECIMAL(7,3) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (address) — VARCHAR(255) — NOT NULL
- Field (favorite) — TINYINT(1) — NOT NULL
- Field (eventdate) — DATETIME — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (room)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (type) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Key (location_from) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Key (location_to) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (departuredate) — DATETIME — NOT NULL
- Field (arrivaldate) — DATETIME
- Field (person_limit) — INT(10) — NOT NULL
- Field (score_limit) — INT(10)
- Field (gender_limit) — TINYINT(1) — NOT NULL
- Field (layover_allowed) — TINYINT(1) — NOT NULL
- Field (fee) — INT(10)
- Field (favorite) — TINYINT(1) — NOT NULL
- Field (lock) — TINYINT(1) — NOT NULL
- Field (log_show) — TINYINT(1) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (deletedate) — DATETIME
Untitled (email_verification)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (date_expired) — DATETIME — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (verification_key) — VARCHAR(255) — NOT NULL
- Field (status) — INT(7) — NOT NULL
Untitled (university)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (mail_domain) — VARCHAR(255)
- Field (code) — VARCHAR(255) — NOT NULL
Untitled (logged_in)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (version) — VARCHAR(20)
- Field (remote_addr) — DATETIME — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
client (user)
- id — VARCHAR(36) — Primary key — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (gender) — INT(7) — NOT NULL
- Field (phone) — VARCHAR(255) — NOT NULL
- Field (create_ip) — VARCHAR(255) — NOT NULL
- Field (role) — INT(7) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
- Field (deletedate) — DATETIME
- Field (freq_reporter) — TINYINT(1) — NOT NULL