마도거래소 V2

테이블 (12)

Account (accounts)

  • id (Key) — bgint — 기본 키 — NOT NULL
  • accountNumber (Field) — VARCHAR(50)
  • balance (Field2) — bgint
  • status (Field3) — ENUM
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

Bank (banks)

  • id (Key) — 기본 키 — NOT NULL
  • name (은행이름) — bgint
  • field (분야) — ENUM
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

Log (logs)

  • Field
  • Field2

News (news)

  • Key — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(255)
  • contents (Field2) — VARCHAR(255)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • news_type (Field5) — ENUM(메인, 서비)
  • race (Field6) — ENUM

Notification (notifications)

  • id (Key) — bgint — 기본 키 — NOT NULL
  • user_id (Key2) — bgint — 외래 키 → User.id — NOT NULL
  • notification_type (Field) — int
  • identifier (Field2) — varchar(50)
  • is_read (Field3) — boolean
  • is_valid (Field4) — boolean
  • created_at (Field5) — timestamp

PortPolio (portpolios)

  • id (PK) — bgint — 기본 키 — NOT NULL
  • user_id (FK) — bgint — 외래 키 → User.id — NOT NULL
  • stock_id (FK2) — bgint — 외래 키 → Stock.id — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp
  • price (Field3) — bgint
  • quantity (Field4) — bgint

Review (reviews)

  • Key — 기본 키 — NOT NULL
  • user_id (FK) — bgint — 외래 키 → User.id — NOT NULL
  • new_id (FK2) — bigint — 외래 키 → News.Key — NOT NULL
  • title (Field)
  • content (Field2)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

Stock (stocks)

  • id (PK) — bgint — 기본 키 — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

Stockinfo (stock_info)

  • Key (PK) — bgint — 기본 키 — NOT NULL
  • stock_id (FK) — bgint — 외래 키 → Stock.id — NOT NULL
  • race (Field) — VARCHAR(50)
  • name (Field2) — VARCHAR(50)
  • field (Field3) — VARCHAR(255)
  • description (Field4) — VARCHAR(255)
  • stock_image (Field5) — VARCHAR(255)

Stockprice (stockprice)

  • Key — 기본 키 — NOT NULL
  • stock_id (FK) — bgint — 외래 키 → Stock.id — NOT NULL
  • quantity (Field) — bgint
  • price (Field2) — bgint
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

Transaction (transactions)

  • Key (PK) — bgint — 기본 키 — NOT NULL
  • user_id (FK) — bgint — 외래 키 → User.id — NOT NULL
  • stock_id (FK2) — bgint — 외래 키 → Stock.id — NOT NULL
  • transaction_status (Field) — ENUM
  • quantity (Field2) — bgint
  • price (Field3) — bgint
  • created_at (Field4) — timestamp

User (users)

  • id (PK) — bgint — 기본 키 — NOT NULL
  • email (Field) — VARCHAR(20)
  • password (Field2) — VARCHAR(20)
  • user_role (Field3) — ADMIN, USER
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • balance (Field6) — bgint