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