re:bin

Tables (11)

admin_member (관리자)

  • id (관리자번호) — BIGINT — Primary key — NOT NULL
  • login_id (로그인아이디)
  • password (비밀번호) — VARCHAR(255)

comment (댓글)

  • id (댓글번호) — Primary key — NOT NULL
  • review_id (리뷰번호) — Foreign key → review.id — NOT NULL
  • content (내용)
  • created_at (작성일자)
  • modifed_at (수정일자)

inquiry (문의)

    member (고객)

    • id (고객id) — BIGINT — Primary key — NOT NULL
    • login_id (소셜로그인아이디) — VARCHAR
    • name (이름) — VARCHAR(45)
    • nickname (닉네임) — VARCHAR(45)
    • phone (전화번호) — VARCHAR(45)
    • email (이메일) — VARCHAR
    • provider (소셜로그인공급자) — ENUM('KAKAO', 'GOOGLE')
    • created_at (가입일자) — TIMESTAMP()
    • modified_at (수정일자) — TIMESTAMP()

    notice (공지사항)

    • id (공지사항번호) — Primary key — NOT NULL
    • title (제목)
    • content (내용)
    • created_at (작성일자)
    • modifed_at (수정일자)

    product (상품)

    • id (상품id) — BIGINT — Primary key — NOT NULL
    • name (상품이름)
    • price (상품가격)
    • summary (상품요약)
    • description (상품 설명)
    • thumbnail (썸네일)
    • created_at (등록일자)
    • modifed_at (수정일자)
    • extra_person_fee (인원추가비용)
    • guide_line (예약 전 안내사항)

    product_image (상품_이미지)

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

    product_like (상품 좋아요)

    • member_id (고객id) — BIGINT — Foreign key → member.id — NOT NULL — unique
    • product_id (상품id) — BIGINT — Foreign key → product.id — NOT NULL

    reservation (예약)

    • id (예약번호) — BIGINT — Primary key — NOT NULL
    • product_id (상품id) — BIGINT — Foreign key → product.id — NOT NULL
    • member_id (고객id) — BIGINT — Foreign key → member.id — NOT NULL
    • time_slot_id (타임슬롯번호) — Foreign key → time_slot.id — NOT NULL
    • reservation_no (예약번호_전략(RE20240925+ABC)) — VARCHAR(45)
    • start_time (예약시작시간)
    • status (예약상태(입금전,입금후,취소됨,촬영완료))
    • is_agree (인스타 업로드 동의 여부)
    • people_cnt (인원)
    • notes (요청사항)
    • price (총 가격)
    • modified_at (수정일자)
    • created_at (예약 생성일자)

    review (리뷰)

    • id (리뷰번호) — BIGINT — Primary key — NOT NULL
    • reservation_id (예약번호) — BIGINT — Foreign key → reservation.id — NOT NULL
    • member_id (고객id) — BIGINT — Foreign key → member.id — NOT NULL
    • product_id (상품id) — BIGINT — Foreign key → product.id — NOT NULL
    • help_cnt (도움돼요 개수)
    • content (내용)
    • created_at (작성일자)
    • modified_at (수정일자)

    time_slot (타임슬롯)

    • id (타임슬롯번호) — Primary key — NOT NULL
    • date (날짜)
    • start_time (시작시간)
    • is_available (예약 가능 여부)