ERD 최종

테이블 (21)

Bill

  • bill_id — VARCHAR(50) — 기본 키 — NOT NULL
  • due_date — VARCHAR(200) — NOT NULL
  • amount — INT — NOT NULL
  • bill_type_id — VARCHAR(50) — 외래 키 → BillType.bill_type_id — NOT NULL

BillType

  • bill_type_id — VARCHAR(50) — 기본 키 — NOT NULL
  • bill_type_name — VARCHAR(20) — NOT NULL

Breed

  • breed_id — VARCHAR(50) — 기본 키 — NOT NULL
  • breed_name — VARCHAR(20) — NOT NULL

Cat

  • cat_id — VARCHAR(50) — 기본 키 — NOT NULL
  • cat_name — VARCHAR(20) — NOT NULL
  • sex — CHAR(1)
  • age — INT
  • adoption_date — VARCHAR(200)
  • note — INT
  • user_id — VARCHAR(50) — 외래 키 → User.user_id — NOT NULL
  • breed_id — VARCHAR(50) — 외래 키 → Breed.breed_id — NOT NULL

CatCattlemUse

  • cat_id — VARCHAR(50) — 외래 키 → Cat.cat_id — NOT NULL
  • cattlem_id — VARCHAR(50) — 외래 키 → Cattlem.cattlem_id — NOT NULL

CatLog

  • log_id — VARCHAR(50) — 기본 키 — NOT NULL
  • log_date — VARCHAR(200) — NOT NULL
  • meal_amount — VARCHAR(50)
  • stool_status — VARCHAR(50)
  • condition — VARCHAR(50)
  • special_behavior — INT
  • cat_id — VARCHAR(50) — 외래 키 → Cat.cat_id — NOT NULL

CatVisit

  • visit_id — VARCHAR(50) — 기본 키 — NOT NULL
  • cat_id — VARCHAR(50) — 외래 키 → Cat.cat_id — NOT NULL
  • visit_date — VARCHAR(200) — NOT NULL
  • symptom — INT
  • diagnosis — INT
  • prescription — INT
  • fee — INT
  • Field

Cattlem

  • cattlem_id — VARCHAR(50) — 기본 키 — NOT NULL
  • brand — VARCHAR(20) — NOT NULL
  • stock_qty — INT — NOT NULL
  • purchase_date — VARCHAR(200)
  • cattlem_type_id — VARCHAR(50) — 외래 키 → CattlemType.cattlem_type_id — NOT NULL

CattlemType

  • cattlem_type_id — VARCHAR(50) — 기본 키 — NOT NULL
  • type_name — VARCHAR(20) — NOT NULL

CleaningTask

  • cleaning_id — VARCHAR(50) — 기본 키 — NOT NULL
  • task_name — VARCHAR(100) — NOT NULL
  • last_cleaned_date — VARCHAR(200)
  • user_id — VARCHAR(50) — 외래 키 → User.user_id — NOT NULL
  • cycle_type_id — VARCHAR(50) — 외래 키 → CycleType.cycle_type_id — NOT NULL

CycleType

  • cycle_type_id — VARCHAR(50) — 기본 키 — NOT NULL
  • cycle_name — VARCHAR(20) — NOT NULL

FoodCategory

  • food_category_id — VARCHAR(50) — 기본 키 — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL

FoodItem

  • food_item_id — VARCHAR(50) — 기본 키 — NOT NULL
  • food_name — VARCHAR(20) — NOT NULL
  • purchase_date — VARCHAR(200)
  • expire_date — VARCHAR(200)
  • storage_location — VARCHAR(100)
  • user_id — VARCHAR(50) — 외래 키 → User.user_id — NOT NULL
  • food_category_id — VARCHAR(50) — 외래 키 → FoodCategory.food_category_id — NOT NULL

HouseholdItem

  • household_item_id — VARCHAR(50) — 기본 키 — NOT NULL
  • item_name — VARCHAR(20) — NOT NULL
  • stock_qty — INT — NOT NULL
  • unit_price — INT
  • item_category_id — VARCHAR(50) — 외래 키 → ItemCategory.item_category_id — NOT NULL

ItemCategory

  • item_category_id — VARCHAR(50) — 기본 키 — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL

Payment

  • payment_id — VARCHAR(50) — 기본 키 — NOT NULL
  • payment_date — VARCHAR(200) — NOT NULL
  • payment_amount — INT — NOT NULL
  • user_id — VARCHAR(50) — 외래 키 → User.user_id — NOT NULL
  • bill_id — VARCHAR(50) — 외래 키 → Bill.bill_id — NOT NULL
  • payment_method_id — VARCHAR(50) — 외래 키 → PaymentMethod.payment_method_id — NOT NULL

PaymentMethod

  • payment_method_id — VARCHAR(50) — 기본 키 — NOT NULL
  • method_name — VARCHAR(20) — NOT NULL

Purchase

  • purchase_id — VARCHAR(50) — 기본 키 — NOT NULL
  • quantity — INT — NOT NULL
  • purchase_date — VARCHAR(200) — NOT NULL
  • usage_place — VARCHAR(100)
  • user_id — VARCHAR(50) — 외래 키 → User.user_id — NOT NULL
  • household_item_id — VARCHAR(50) — 외래 키 → HouseholdItem.household_item_id — NOT NULL

User

  • user_id — VARCHAR(50) — 기본 키 — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20)
  • move_in_date — DATE
  • residence_info — INT
  • monthly_budget — INT
  • monthly_expense — INT

Vaccination

  • vaccination_id — VARCHAR(50) — 기본 키 — NOT NULL
  • vaccine_name — VARCHAR(20) — NOT NULL
  • vaccination_date — VARCHAR(200) — NOT NULL
  • cat_id — VARCHAR(50) — 외래 키 → Cat.cat_id — NOT NULL

VetClinic

  • clinic_id — VARCHAR(50) — 기본 키 — NOT NULL
  • clinic_name — VARCHAR(20) — NOT NULL
  • phone — DATE
  • address — VARCHAR(200)
  • cat_id — VARCHAR(50) — 외래 키 → Cat.cat_id — NOT NULL