linkle
Tables (9)
class_reservations
- id — BIGINT
- class_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- qty — TINYINT
- payment_status — ENUM('PENDING','PAID','REFUNDED')
- status — ENUM('RESERVED','CANCELLED')
classes
- id — BIGINT
- instructor_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(12,2) — NOT NULL
- start_dt — DATETIME — NOT NULL
- end_dt — DATETIME — NOT NULL
- capacity — INT — NOT NULL
- status — ENUM('SCHEDULED','CANCELLED','COMPLETED')
- created_at — TIMESTAMP
- INDEX — idx_instructor_time
mentoring_sessions
- id — BIGINT
- mentor_id — BIGINT — NOT NULL
- mentee_id — BIGINT — NOT NULL
- scheduled_at — DATETIME — NOT NULL
- status — ENUM('REQUESTED','ACCEPTED','COMPLETED','CANCELLED')
- rating — TINYINT
- created_at — TIMESTAMP
- INDEX — idx_mentor_status
product_images
- id — BIGINT
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — TINYINT
- created_at — TIMESTAMP
- INDEX — idx_product_order
product_options
- product_id — BIGINT — Primary key — NOT NULL
- opt_key — VARCHAR(50) — Primary key — NOT NULL
- opt_val — VARCHAR(50) — Primary key — NOT NULL
- extra_price — DECIMAL(12,2)
- stock — INT
products
- id — BIGINT
- seller_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category — ENUM('HANDCRAFT','DECOR','ACCESSORY','KITCHEN','STATIONERY')
- price — DECIMAL(12,2) — NOT NULL
- stock — INT
- status — ENUM('DRAFT','ACTIVE','INACTIVE')
- created_at — TIMESTAMP
- INDEX — idx_seller_status
roles
- id — TINYINT
- name — VARCHAR(30)
user_roles
- user_id — BIGINT — Primary key — NOT NULL
- role_id — TINYINT — Primary key — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARBINARY(255)
- name — VARCHAR(100) — NOT NULL
- status — ENUM('ACTIVE','BANNED')
- created_at — TIMESTAMP