cenimarket
Tables (12)
categories
- id — BIGINT
- parent_id — BIGINT — Foreign key → categories.id
- name — VARCHAR(100) — NOT NULL
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
chat_messages
- id — BIGINT
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- message_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
chat_room_members
- id — BIGINT
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- last_read_message_id — BIGINT — Foreign key → chat_messages.id
- last_read_at — DATETIME
- created_at — DATETIME — NOT NULL
chat_rooms
- id — BIGINT
- listing_id — BIGINT — Foreign key → listings.id — NOT NULL
- buyer_id — BIGINT — Foreign key → users.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- last_message_id — BIGINT — Foreign key → chat_messages.id
- last_message_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
email_verifications
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id
- email — VARCHAR(255) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- purpose — VARCHAR(30) — NOT NULL
- expires_at — DATETIME — NOT NULL
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
listing_images
- id — BIGINT
- listing_id — BIGINT — Foreign key → listings.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
listing_likes
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- listing_id — BIGINT — Foreign key → listings.id — NOT NULL
- created_at — DATETIME — NOT NULL
listings
- id — BIGINT
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id
- type — VARCHAR(20) — NOT NULL
- title — VARCHAR(150) — NOT NULL
- description — TEXT — NOT NULL
- price — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
- published_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
notifications
- id — BIGINT — Primary key — NOT NULL
- notification_type — VARCHAR(31) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- noti_type — VARCHAR(50) — NOT NULL
- receiver_id — BIGINT — NOT NULL
- chat_room_id — BIGINT
- sender_id — BIGINT
- message_preview — VARCHAR(255)
- message_type — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
refresh_tokens
- id — BIGINT — Primary key — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expire_date — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
transactions
- id — BIGINT
- listing_id — BIGINT — Foreign key → listings.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- buyer_id — BIGINT — Foreign key → users.id
- type — VARCHAR(20) — NOT NULL
- price — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- email_verified_at — DATETIME
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL