louishome_kiosk
Tables (22)
Brand (브랜드)
- name (이름) — NOT NULL — Primary key
- Field
Breed (종)
- id (Key) — Primary key — NOT NULL
- name (종) — NOT NULL
- size (종류)
Cart (장바구니)
- id (Key) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- product_count (수량) — NOT NULL
- Field
Health (건강고려사항)
- id (health_id) — NOT NULL — Primary key — NOT NULL
- name (이름) — NOT NULL
- type (Field)
Ingredient (원료)
- id (alg_id) — NOT NULL — Primary key — NOT NULL
- name (이름) — NOT NULL
- Field
Life_Stage (생애주기)
- name (이름) — NOT NULL — Primary key
- Field
Order (주문)
- id (order_id) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- receiver_name (받는 사람) — NOT NULL
- receiver_phone (받는 사람 연락처) — NOT NULL
- recipient_address (받는 사람 주소) — NOT NULL
- order_status (주문 상태) — NOT NULL
- created_at (주문 시점) — NOT NULL
- delivered_at (배송 완료 시점) — NOT NULL
- Field
Pet (펫)
- id (pet_id) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- pet (동물 종류) — NOT NULL
- name (이름) — NOT NULL
- breed (종) — NOT NULL
- birth (생일) — NOT NULL
- gender (성별) — NOT NULL
- neutering (중성화) — NOT NULL
- weight (몸무게)
- Field
Pet_Allergy (펫 알레르기)
- id (키) — NOT NULL — Primary key — NOT NULL
- id (pet_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- id (user_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- id (alg_id) — NOT NULL — Foreign key → Ingredient.id — NOT NULL
- is_main (메인 알러지 여부) — NOT NULL
- Field
Pet_Health (펫 건강고려사항)
- id (health_id) — NOT NULL — Foreign key → Health.id — NOT NULL
- id (pet_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- id (user_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- is_main (메인 알러지 여부) — NOT NULL
Pet_Product (먹을수있는 사료)
- id (Key) — NOT NULL — Primary key — NOT NULL
- id (pet_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- id (user_id) — NOT NULL — Foreign key → Pet.id — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- Field
Pet_Type (반려동물 종류)
- name (강아지 or 고양이) — NOT NULL — Primary key — NOT NULL
Product (상품)
- id (product_id) — NOT NULL — Primary key — NOT NULL
- pet (대상) — NOT NULL
- name (이름) — NOT NULL
- short_name (짧은 이름) — NOT NULL
- eng_name (영어 이름) — NOT NULL
- shape (사료형태) — NOT NULL
- brand (브랜드)
- life_stage (생애주기) — NOT NULL
- size (크기) — NOT NULL
- main_ingredient (주원료)
- all_ingredient (전성분) — NOT NULL
- health_1 (건강사항1)
- health_2 (건강사항2)
- health_3 (건강사항3)
- kibble (알갱이 크기) — NOT NULL
- protein (조단백)
- protein_dm (조단백_수분제거)
- fat (조지방)
- fat_dm (조지방_수분제거)
- fiber (조섬유)
- fiber_dm (조섬유_수분제거)
- ash (조회분)
- ash_dm (조회분_수분제거)
- calcium (칼슘)
- calcium_dm (칼슘_수분제거)
- phosphorus (인)
- phosphorus_dm (인_수분제거)
- omega6 (오메가6)
- omega3 (오메가3)
- DHA
- EPA
- glucosamine (글루코사민)
- chondroitin (콘드로이틴)
- vitamin_e (비타민E)
- kcal (100g/cal)
- retail_price (판매가) — NOT NULL
- weight (무게)
- hash (해시태그) — NOT NULL
- explain_titles (상세설명 타이틀) — NOT NULL
- explain_contents (상세설명 컨텐츠) — NOT NULL
- created_at (생성날짜) — NOT NULL
- modified_at (수정날짜) — NOT NULL
- link (웹 링크) — NOT NULL
- is_active (활성화) — NOT NULL
- Field
Product_Allergy (제품 알레르기)
- id (키) — NOT NULL — Primary key — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- id (alg_id) — NOT NULL — Foreign key → Ingredient.id — NOT NULL
- alg_type (메인 or 서브) — NOT NULL
- Field
Product_Health (제품 건강고려사항)
- id (키) — NOT NULL — Primary key — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- id (health_id) — NOT NULL — Foreign key → Health.id — NOT NULL
Product_Photo (제품 사진)
- id (product_photo_id) — NOT NULL — Primary key — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- photo_url (이미지 주소) — NOT NULL
- Field
Shipping_Address (배송지 주소)
- id (Shipping_Address_id) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- address (주소) — NOT NULL
- is_default (기본배송지 여부) — NOT NULL
- Field
Size (크기)
- name (이름) — NOT NULL — Primary key
- Field
Store (매장)
- id (store_id) — NOT NULL — Primary key — NOT NULL
- name (매장 이름) — NOT NULL
- username (로그인 아이디) — NOT NULL
- password (비밀번호) — NOT NULL
- address (주소) — NOT NULL
- is_active (활성화) — NOT NULL
- number (전화번호) — NOT NULL
- created_at (생성 날짜)
Store_Product (매장 제품)
- id (Store_Product_id) — NOT NULL — Primary key — NOT NULL
- id (store_id) — NOT NULL — Foreign key → Store.id — NOT NULL
- id (product_id) — NOT NULL — Foreign key → Product.id — NOT NULL
- location (제품 위치) — NOT NULL
- product_count (제품 수량) — NOT NULL
- product_state (제품 판매 상태(오프라인, 온라인)) — NOT NULL
- is_active (활성화여부) — NOT NULL
- Field
User (회원)
- id (user_id) — NOT NULL — Primary key — NOT NULL
- username (로그인 아이디) — NOT NULL
- password (비밀번호) — NOT NULL
- first_name (이름) — BLANK
- last_name (성) — BLANK
- email (이메일) — BLANK
- groups (그룹)
- user_permissions (유저 권한)
- is_staff (스태프 권한) — NOT NULL
- is_active (활성화) — NOT NULL
- is_superuser (수퍼유저 권한) — NOT NULL
- last_login (마지막 로그인)
- date_joined (계정 생성)
- phonenumber (휴대폰 번호) — NOT NULL
- birth (생일) — NOT NULL
- gender (성별) — NOT NULL
- Field
membership (회원 등급)
- id (Key) — NOT NULL — Primary key — NOT NULL
- id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- name (등급) — NOT NULL
- Field