2023-cloud-programming
Tables (3)
User (사용자)
- id (사용자pk) — Primary key — NOT NULL
- login_id (사용자id)
- password (비밀번호)
account (가계)
- id (가계pk) — Primary key — NOT NULL
- date (날짜)
- store_id (상가pk) — Foreign key → store.id — NOT NULL
- user_id (사용자pk) — Foreign key → User.id — NOT NULL
- type (수입/지출)
- tag (수입/지출 타입)
- is_public (공개여부)
- description (설명)
store (상가)
- id (상가pk) — Primary key — NOT NULL
- name (가게명)
- city (시도)
- county (시군구)
- industry (업종분류)