규정스의하입클로바요

테이블 (8)

Answers (kid_answer)

  • answer_id (PK) — INT — 기본 키 — NOT NULL
  • question_id (PK2) — INT — 외래 키 → Questions.question_id — NOT NULL
  • kid_id (PK3) — INT — 외래 키 → Kids.kid_id — NOT NULL
  • parent_id (PK22) — INT — 외래 키 → Kids.parent_id — NOT NULL
  • answer_text (Field) — TEXT
  • answer_date (Field2) — TIMESTAMP

Concept (concept)

  • Concept_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(100)
  • description (Field2)

Kids (kid)

  • kid_id (PK) — INT — 기본 키 — NOT NULL
  • user_id (Key) — INT — 외래 키 → Users.user_id — NOT NULL
  • parent_id (PK2) — INT — 외래 키 → Parents.parent_id — NOT NULL
  • age (Field) — INT

News (news)

  • news_id (PK) — INT — 기본 키 — NOT NULL
  • content (Field2) — TEXT
  • title (Field3) — VARCHAR(255)]
  • published_date (Field) — Date

Parents (parent)

  • parent_id (PK) — INT — 기본 키 — NOT NULL
  • user_id (Key) — INT — 외래 키 → Users.user_id — NOT NULL
  • user_id (FK) — INT
  • bank_account (Field) — VARCHAR(100)
  • balance (Field2)

Questions (Question)

  • question_id (PK) — INT — 기본 키 — NOT NULL
  • news_id (FK) — INT — 외래 키 → News.news_id — NOT NULL
  • Concept_id (FK2) — INT — 외래 키 → Concept.Concept_id — NOT NULL
  • question_text (Field) — TEXT

Transactions (between kid and parent)

  • transaction_id (PK) — INT — 기본 키 — NOT NULL
  • parent_id (FK1) — INT — 외래 키 → Parents.parent_id — NOT NULL
  • kid_id (FK2) — INT — 외래 키 → Kids.kid_id — NOT NULL
  • parent_id (PK2) — INT — 외래 키 → Kids.parent_id — NOT NULL
  • amount (Field) — DECIMAL(10, 2)
  • transaction_date (Field2)

Users (All Users)

  • user_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHER(20)
  • email (Field2) — VARCHER(40)
  • password (Field3) — VARCHAR(50)
  • role (Field4) — BOOL