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