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 (수정일자)
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 (예약 가능 여부)