kids_system

Tables (6)

account (Untitled3)

  • account_id (id) — int — Primary key — NOT NULL
  • 학부모 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 학부모 이름 (name) — varchar
  • 학부모 연락처 (phone_number) — varchar
  • 자녀 list (kids)
  • uuid

bank_account (Untitled6)

  • bank_account_id (id) — int — Primary key — NOT NULL
  • account_id — int — Foreign key → account.account_id — NOT NULL
  • 계좌명 (account_name) — varchar
  • 은행명 (bank_name) — varchar
  • 계좌번호 (account_number) — varchar
  • 현금영수증 발행 번호 (cash_receipt_number) — varchar
  • uuid

contract_package (Untitled5)

  • contract_package_id (id) — int — Primary key — NOT NULL
  • kid_id — int — Foreign key → kid.kid_id — NOT NULL
  • 계약 자녀 (kid)
  • 계약 패키지 (package)
  • 사용 시작일 (started_at) — unixtimestamp
  • 사용 종료일 (ended_at) — unixtimestamp
  • 일시중단 시작일 (pause_started_at) — unixtimestamp
  • 일시중단 종료일 (pause_ended_at) — unixtimestamp
  • uuid

kid (Untitled4)

  • kid_id (id) — int — Primary key — NOT NULL
  • kindergarten_room_id — int — Foreign key → kindergarten_room.kindergarten_room_id — NOT NULL
  • kindergarten_id — int — Foreign key → kindergarten_room.kindergarten_id — NOT NULL
  • account_id — int — Foreign key → account.account_id — NOT NULL
  • 자녀 이름 (name) — varchar
  • 계약 패키지 (contract_package)
  • 소속 반 (kindergarten_room) — varchar
  • uuid

kindergarten (Untitled)

  • kindergarten_id (id) — int — Primary key — NOT NULL
  • 유치원이름 (name) — varchar
  • 유치원코드 (code) — varchar
  • 주소 (address) — varchar
  • 보유 반 list (rooms) — varchar
  • uuid

kindergarten_room (Untitled2)

  • kindergarten_room_id (id) — int — Primary key — NOT NULL
  • kindergarten_id — int — Foreign key → kindergarten.kindergarten_id — NOT NULL
  • 반 이름 (name) — varchar
  • uuid