renpick

Tables (14)

admin

  • id — INT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

card

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(2048)
  • max_monthly_discount — INT — NOT NULL
  • inquiry_number — VARCHAR(255) — NOT NULL
  • auto_pay_number — VARCHAR(255) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

category

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)

category_option

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • display_order — INT — NOT NULL
  • category_id — INT — Foreign key → category.id — NOT NULL

category_option_value

  • id — INT
  • value — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • display_order — INT — NOT NULL
  • option_id — INT — Foreign key → category_option.id — NOT NULL

product

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • model_number — VARCHAR(255) — NOT NULL
  • brand — VARCHAR(255) — NOT NULL
  • management_type — ENUM('visit', 'self', 'both') — NOT NULL
  • initial_cost_exemption — BOOLEAN — NOT NULL
  • contract_pricing — JSON — NOT NULL
  • description — TEXT
  • is_best — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • category_id — INT — Foreign key → category.id — NOT NULL
  • subcategory_id — INT — Foreign key → subcategory.id

product_card

  • id — INT
  • additional_benefits — VARCHAR(255)
  • product_id — INT — Foreign key → product.id — NOT NULL
  • card_id — INT — Foreign key → card.id — NOT NULL

product_image

  • id — INT
  • url — VARCHAR(2048) — NOT NULL
  • type — ENUM('main', 'detail') — NOT NULL
  • order — INT — NOT NULL
  • alt_text — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • product_id — INT — Foreign key → product.id — NOT NULL

product_option

  • id — INT
  • product_id — INT — Foreign key → product.id — NOT NULL
  • option_id — INT — Foreign key → category_option.id — NOT NULL
  • value_id — INT — Foreign key → category_option_value.id — NOT NULL

review

  • id — INT
  • product_id — INT — Foreign key → product.id — NOT NULL — 리뷰 대상 상품 FK
  • user_id — INT — Foreign key → user.id — 작성자 FK (회원일 경우)
  • content — TEXT — NOT NULL — 리뷰 내용
  • rating — INT — NOT NULL — 별점
  • guest_nickname — VARCHAR(100) — 비회원용 닉네임
  • guest_password_hash — VARCHAR(255) — 비회원 리뷰 수정/삭제용 비밀번호 해시
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

review_image

  • id — INT
  • review_id — INT — Foreign key → review.id — NOT NULL — 리뷰 FK
  • image_url — VARCHAR(2048) — NOT NULL — 이미지 S3 URL
  • display_order — INT — NOT NULL — 이미지 표시 순서
  • created_at — TIMESTAMP — NOT NULL

subcategory

  • id — INT
  • name — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • category_id — INT — Foreign key → category.id — NOT NULL

subscription

  • id — INT
  • product_id — INT — Foreign key → product.id — NOT NULL
  • user_id — INT — Foreign key → user.id — 신청자 FK (회원일 경우)
  • user_name — VARCHAR(255) — NOT NULL — 신청자 실명
  • user_phone — VARCHAR(255) — NOT NULL — 신청자 연락처
  • selected_term — INT — NOT NULL
  • management_type — ENUM('visit', 'self', 'both') — NOT NULL
  • application_type — ENUM('consultation', 'subscription') — NOT NULL
  • rental_price — INT — NOT NULL
  • customer_memo — TEXT
  • admin_memo — TEXT
  • status — ENUM('pending', 'contacted', 'completed') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user

  • id — INT — 사용자 고유 ID
  • email — VARCHAR(255) — NOT NULL — 로그인 이메일
  • password — VARCHAR(255) — NOT NULL — 해시된 비밀번호
  • nickname — VARCHAR(100) — NOT NULL — 닉네임
  • created_at — TIMESTAMP — NOT NULL — 가입일
  • updated_at — TIMESTAMP — NOT NULL — 마지막 정보 수정일