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 — 마지막 정보 수정일