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