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