talk_service2
Tables (17)
cars_details (Untitled8)
- cart_id (Key) — BIGINT — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → cart.id — NOT NULL
- id (Key22) — Domain — Foreign key → cart.id — NOT NULL
- cos_id (Field) — BIGINT
- price (Field2) — BIGINT
cart (Untitled7)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → user.id — NOT NULL
- user_id (Field) — Domain
- total_price (Field2) — Domain
cart_details (Untitled19)
- cart_id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → course.id — NOT NULL
- id (Key22) — Domain — Foreign key → course.id — NOT NULL
- cos_id (Field) — Domain
- price (Field2) — Domain
comment (Untitled5)
- id (Key) — Domain — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
- contents (Field3) — Domain
- refer_to (Field4) — Domain
cos_progress (Untitled15)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key3) — Domain — Foreign key → course.id — NOT NULL
- id (Key22) — Domain — Foreign key → course.id — NOT NULL
- user_id (Field) — Domain
- cos_id (Field2) — Domain
- viewtime (Field3) — BIGINT
- progress (Key2) — DECIMAL — NOT NULL
cos_tag (Untitled14)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → course.id — NOT NULL
- id (Key22) — Domain — Foreign key → course.id — NOT NULL
- cos_id (Field) — Domain
- title (Field2) — Domain
cos_video (Untitled9)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → course.id — NOT NULL
- id (Key22) — Domain — Foreign key → course.id — NOT NULL
- cos_id (Field) — Domain
- title (Field2) — Domain
- vid_length (Field3) — Domain
- link (Field4) — Domain
course (Untitled11)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → structers.id — NOT NULL
- ins_id (Field) — Domain
- title (Field2) — Domain
- detail (Field3) — Domain
- price (Field4) — Domain
- create_time (Field5) — Domain
- photo (Field6) — Domain
- cos_length (Field7) — Domain
- rating (Field8) — Domain
- students (Field9) — Domain
job (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- job_id (Key2) — BIGINT — Foreign key → job_cos.job_id — NOT NULL
- cos_id (Key22) — BIGINT — Foreign key → job_cos.cos_id — NOT NULL
- name (Field) — VARCHAR(255)
- target (Field2) — VARCHAR(255)
- requirements (Field3) — VARCHAR(255)
- area (Field4) — VARCHAR(255)
job_cos (Untitled10)
- job_id (Key2) — BIGINT — Foreign key → course.id — NOT NULL
- cos_id (Key22) — BIGINT — Foreign key → course.id — NOT NULL
orders (Untitled16)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → user.id — NOT NULL
- user_id (Field) — Domain
- ord_status (Field2) — Domain
- total (Field3) — Domain
- method (Field4) — Domain
- pay_info (Field5) — Domain
- payer_name (Field6) — Domain
- comp (Field7) — Domain
orders_detail (Untitled18)
- ord_id (Key) — Domain — Primary key — NOT NULL
- cos_id (Field) — Domain
- price (Field2) — Domain
- payment_time (Field3) — Domain
post (Untitled6)
- id (Key) — Domain — Primary key — NOT NULL
- id (Key2) — Domain — Foreign key → user.id — NOT NULL
- user_id (Field) — Domain
- title (Field2) — Domain
- contents (Field3) — Domain
- created_time (Field4) — Domain
- solved (Field5) — Domain
- post_type (Field6) — Domain
review (Untitled4)
- id (Key) — Domain — Primary key — NOT NULL
- user_id (Key2) — Domain — Foreign key → course.id — NOT NULL
- cos_id (Key22) — Domain — Foreign key → course.id — NOT NULL
- id (Key3) — Domain — Foreign key → user.id — NOT NULL
- created_time (Field) — DATETIME
- rating (Field2) — Domain
- contents (Field3) — Domain
structers (Untitled3)
- id (Key) — Domain — Primary key — NOT NULL
- user_id (Field) — Domain
- profi;e (Field2) — Domain
- career (Field3) — Domain
- rating (Field4) — Domain
- students (Field5) — Domain
user (Untitled13)
- id (Key) — Domain — Primary key — NOT NULL
- email (Field) — Domain
- password (Field2) — Domain
- name (Field3) — Domain
- age (Field4) — Domain
- role (Key2) — Domain — NOT NULL
- phone (Field5) — Domain
view_time (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- vid_id (Field) — BIGINT
- user_id (Field2) — BIGINT
- view_length (Field3) — BIGINT