글로벌인
테이블 (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