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)