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