soop_blockchain

Tables (6)

product (상품)

  • product_id (Key) — BIGINT — Primary key — NOT NULL
  • name (상품이름) — VARCHAR(45)
  • price (가격) — INT
  • summary (요약) — VARCHAR(45)
  • description (설명) — TEXT()
  • thumbnail (썸네일) — VARCHAR(255)

product_image (상품_이미지)

  • image_id (Key) — BIGINT — Primary key — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → product.product_id — NOT NULL
  • url (이미지 경로) — VARCHAR(255)

reservation (예약)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • time_slot_id (타임슬롯id) — BIGINT — Foreign key → time_slot.timeslot_id — NOT NULL
  • user_id (예약자) — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → product.product_id — NOT NULL
  • reservation_number (예약번호) — VARCAHR(45)
  • status (예약상태) — ENUM('RESERVED', 'CANCELED','COMPLETED')
  • created_at (예약시간) — TIMESTAMP()

review (리뷰)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (리뷰 작성자) — BIGINT — Foreign key → user.user_id — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → product.product_id — NOT NULL
  • reservation_id (예약번호) — BIGINT — Foreign key → reservation.id — NOT NULL
  • content (내용) — TINYTEXT
  • created_at (생성일자) — TIMESTAMP()
  • modified_at (수정일자) — TIMESTAMP()

time_slot (타임슬롯)

  • timeslot_id (Key) — BIGINT — Primary key — NOT NULL
  • date (날짜) — DATE()
  • time (시간) — TIME()
  • is_available (가능여부) — BIT(1)

user (사용자)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • login_id (로그인아이디) — VARCHAR(45)
  • nickname (이름) — VARCHAR(10)
  • phone (전화번호) — VARCHAR(11)
  • wallet (지갑 주소) — VARCHAR(45)