글로벌인

테이블 (9)

Admins

  • adminId — VARCHAR(24)
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • role — VARCHAR(50)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Ads

  • adId — VARCHAR(24)
  • productId — VARCHAR(24) — NOT NULL
  • video — VARCHAR(255) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Comments

  • commentId — VARCHAR(24)
  • questionId — VARCHAR(24)
  • content — TEXT
  • adminId — VARCHAR(24)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Faqs

  • faqId — VARCHAR(24)
  • title — VARCHAR(255)
  • content — TEXT
  • adminId — VARCHAR(24)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Payments

  • paymentId — VARCHAR(24)
  • user — JSON
  • data — JSON
  • product — JSON
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Products

  • productId — VARCHAR(24)
  • writer — VARCHAR(24)
  • title — VARCHAR(60)
  • description — TEXT
  • price — INT
  • images — JSON
  • sold — INT
  • category — INT
  • views — INT
  • averageRating — FLOAT
  • reviewCount — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Questions

  • questionId — VARCHAR(24)
  • title — VARCHAR(255)
  • content — TEXT
  • userId — VARCHAR(24)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Reviews

  • reviewId — VARCHAR(24)
  • productId — VARCHAR(24) — NOT NULL
  • userId — VARCHAR(24) — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

Users

  • userId — VARCHAR(24)
  • name — VARCHAR(50)
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — INT
  • cart — JSON
  • history — JSON
  • wishlist — JSON
  • image — VARCHAR(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP