규정스의하입클로바요
테이블 (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