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