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