carshop

Tables (12)

bidding (Untitled3)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (company_summary_id) — BIGINT NOT NULL — Foreign key → company_summary.PK — NOT NULL
  • FK (order_id) — BIGINT NOT NULL — Foreign key → order.PK — NOT NULL
  • Field (detail) — TEXT NOT NULL
  • Field (price) — BIGINT NOT NULL

bidding_history (Untitled11)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (user_id) — BIGINT NOT NULL — Foreign key → user.PK — NOT NULL
  • FK (company_id) — BIGINT NOT NULL — Foreign key → company.PK — NOT NULL
  • Field (detail) — TEXT NOT NULL
  • Field2 (state) — BOOLEAN NOT NULL
  • Field3 (created_time) — DATETIME NOT NULL

company (Untitled8)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • Field (address) — VARCHAR(255) NOT NULL
  • Field2 (introduction) — TEXT
  • Field (products) — VARCHAR(255)
  • Field (boss_name) — VARCHAR(50) NOT NULL
  • Field (email) — VARCHAR(50)
  • Field (phone_number) — VARCHAR(50)
  • Field (login_path) — VARCHAR(10) NOT NULL
  • Field (created_time) — DATETIME NOT NULL

company_image (Untitled9)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (company_id) — BIGINT NOT NULL — Foreign key → company.PK — NOT NULL
  • Field (filename) — VARCHAR(255) NOT NULL
  • Field (image_url) — VARCHAR(255) NOT NULL

company_summary (Untitled5)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (company_id) — BIGINT NOT NULL — Foreign key → company.PK — NOT NULL
  • Field (name) — VARCHAR(50) NOT NULL
  • Field (region) — VARCHAR(50) NOT NULL
  • Field (profile_image_url) — VARCHAR(255)
  • Field (address) — VARCHAR(255) NOT NULL
  • Field (rating) — FLOAT NOT NULL

contract (Untitled6)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (user_id) — BIGINT NOT NULL — Foreign key → user.PK — NOT NULL
  • FK (company_summary_id) — BIGINT NOT NULL — Foreign key → company_summary.PK — NOT NULL
  • Field (order_detail) — TEXT NOT NULL
  • Field (bidding_detail) — TEXT NOT NULL
  • Field (contract_step) — VARCHAR(50) NOT NULL

contract_image (Untitled7)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (contract_id) — BIGINT NOT NULL — Foreign key → contract.PK — NOT NULL
  • Field (filename) — VARCHAR(255) NOT NULL
  • Field (image_url) — VARCHAR(255) NOT NULL
  • Field (contract_step) — VARCHAR(50) NOT NULL

order (Untitled2)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (user_id) — BIGINT NOT NULL — Foreign key → user.PK — NOT NULL
  • Field (detail) — TEXT NOT NULL
  • Field2 (region) — VARCHAR(100) NOT NULL
  • Field3 (expired) — BOOLEAN NOT NULL
  • Field4 (created_time) — DATETIME NOT NULL
  • Field (order_type) — VARCHAR(20) NOT NULL

order_image (Untitled4)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (order_Id) — BIGINT NOT NULL — Foreign key → order.PK — NOT NULL
  • Field (filename) — varchar(255) NOT NULL
  • Field (image_url) — varchar(255) NOT NULL

review (Untitled10)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • FK (user_id) — BIGINT NOT NULL — Foreign key → user.PK — NOT NULL
  • PK (company_id) — BIGINT NOT NULL — Foreign key → company.PK — NOT NULL
  • Field (content) — TEXT NOT NULL
  • Field (created_time) — DATETIME NOT NULL

review_image (CopyOfUntitled9)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • PK (review_id) — BIGINT NOT NULL — Foreign key → review.PK — NOT NULL
  • Field (filename) — VARCHAR(255) NOT NULL
  • Field (image_url) — VARCHAR(255) NOT NULL

user (Untitled)

  • PK (id) — BIGINT NOT NULL — Primary key — NOT NULL
  • Field (email) — VARCHAR(50) NOT NULL
  • Field (login_path) — VARCHAR(10) NOT NULL
  • Field (name) — VARCHAR(50) NOT NULL
  • Field (phone_number) — VARCHAR(50) NOT NULL
  • Field (nickname) — VARCHAR(50)
  • Field (profile_image_url) — VARCHAR(255)
  • Field (created_time) — DATETIME NOT NULL