economic-education-project
테이블 (4)
거래 (Transaction)
- transaction_id (PK) — 기본 키 — NOT NULL
- user_id (FK1) — bigint(20) — 외래 키 → 회원.user_id — NOT NULL
- account_id (FK2) — bigint(14) — 외래 키 → 계좌.account_id — NOT NULL
- transcation_name (Field) — varchar(50)
- transcation_type (Field2) — enum
- created_at (Field3) — datetime
- Field4
계좌 (Account)
- account_id (PK) — bigint(14) — 기본 키 — NOT NULL
- user_id (FK) — bigint(20) — 외래 키 → 회원.user_id — NOT NULL
- account_name (Field) — varchar(15)
- total_amount (Field2) — int
상품 (Products)
- product_id (PK) — int — 기본 키 — NOT NULL
- product_type (Field) — enum
- product_name (Field2) — varchar(50)
- product_description (Field3) — text
- advantage (Field4) — float
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
회원 (Users)
- user_id (PK) — bigint(20) — 기본 키 — NOT NULL
- user_name (Field) — varchar(15)
- description (Field2) — varchar(50)
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
- is_deleted (Field5) — bool