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 (업종분류)