마도거래소 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
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