aaa

Tables (12)

book

  • id — INT
  • isbn — VARCHAR(13) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(255) — NOT NULL
  • publisher — VARCHAR(255)
  • publication_date — DATE
  • category_id — INT

category

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • parent_id — INT
  • created_at — DATETIME

chatting

  • id — INT
  • room_id — INT
  • send_user_id — INT
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

chatting_room

  • id — INT
  • identifier — VARCHAR(100) — NOT NULL
  • last_chat — TEXT
  • created_at — DATETIME

favorite_product

  • member_id) — REFERENCES
  • member_id — INT
  • product_id — INT
  • review_text — TEXT
  • rating — INT
  • created_at — DATETIME

member

  • id — INT
  • userid — VARCHAR(20) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • birth_date — DATE — NOT NULL
  • gender — ENUM('male', 'female', 'other')
  • is_admin — BOOLEAN
  • created_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME
  • agree — BOOLEAN

notification

  • id — INT
  • member_id — INT
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

orders

  • id — INT
  • member_id — INT
  • product_id — INT
  • quantity — INT — NOT NULL
  • order_status — ENUM('Pending', 'Completed', 'Cancelled', 'Refunded')
  • created_at — DATETIME

participant

  • id — INT
  • room_id — INT
  • user_id — INT

payment

  • id — INT
  • product_id — INT
  • order_id — INT
  • quantity — INT — NOT NULL
  • street_address — VARCHAR(255)
  • detail_address — VARCHAR(255)
  • created_at — DATETIME

product

  • id — INT
  • book_id — INT — NOT NULL
  • member_id — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • book_condition — ENUM
  • trade_method — VARCHAR(100)
  • payment_location — VARCHAR(255)
  • description — TEXT
  • created_at — DATETIME
  • product_status — ENUM('Deleted','For Sale', 'Reserved', 'Sold Out')
  • # — product_status
  • book_image — VARCHAR(255)

report

  • id — INT
  • member_id — INT
  • product_id — INT
  • report_reason — TEXT
  • created_at — DATETIME