블록체인ERD
테이블 (7)
Untitled (MEMBER)
- Key (MEMBER_SEQ) — LONG — 기본 키 — NOT NULL
- Field (MEMBER_ID) — VARCHAR(255)
- Field (MEMBER_PASSWORD) — VARCHAR(255)
- Field (MEMBER_ADDRESS) — VARCHAR(255)
- Field (PROFILE_IMAGE_URL) — VARCHAR(255)
- Field (AUTHORITY) — BOOLEAN
- Field (MEMBER_BIO) — VARCHAR(255)
- Field (SSF) — LONG
- Field (REG_DT) — TIMESTAMP
Untitled (NFT)
- Key (NFT_SEQ) — LONG — 기본 키 — NOT NULL
- Field (NFT_AUTHOR_SEQ) — LONG
- Field (NFT_AUTHOR_NAME) — LONG
- Field (NFT_OWNER_SEQ) — LONG
- Field (NFT_OWNER_ADDRESS) — VARCHAR(255)
- Field (NFT_WORK_URI) — VARCHAR(255)
- Field (NFT_METADATA_URI) — VARCHAR(255)
- Field (NFT_NAME) — VARCHAR(255)
- Field (NFT_TYPE) — VARCHAR(255)
- Field (NFT_DESCRIPTION) — VARCHAR(255)
- Field (NFT_CONTRACT_ADDRESS) — VARCHAR(255)
- Field (NFT_TOKEN_ID) — INT
- Field (REG_DT) — TIMESTAMP
- Field (FILE_URL) — VARCHAR(255)
- Field (NFT_ONSALE) — BOOLEAN
Untitled (FILE_LIST)
- Key (FILE_ID) — LONG — 기본 키 — NOT NULL
- Key (NFT_SEQ) — LONG — 외래 키 → Untitled.Key — NOT NULL
- Field (FILE_CONTENT_TYPE) — VARCHAR(255)
- Field (FILE_NAME) — VARCHAR(255)
- Field (FILE_SIZE) — LONG
- Field (FILE_URL) — VARCHAR(255)
- Field (REG_DT) — TIMESTAMP
Untitled (MARKET)
- Key (MARKET_ID) — LONG — 기본 키 — NOT NULL
- Key (NFT_SEQ) — LONG — 외래 키 → Untitled.Key — NOT NULL
- Field (MARKET_CONTRACT_ADDRESS) — VARCHAR(255)
- Field (SELLER) — VARCHAR(255)
- Field (BUYER) — VARCHAR(255)
- Field (PRICE) — LONG
- Field (START_TIME) — DATE
- Field (END_TIME) — DATE
- Field (REG_DT) — TIMESTAMP
- Field (ENDED) — BOOLEAN
- Field (CANCELED) — BOOLEAN
Untitled (EXHIBITION_WORK)
- Key (WORK_ID) — LONG — 기본 키 — NOT NULL
- Key (EXHIBITION_ID) — LONG — 외래 키 → Untitled.Key — NOT NULL
- Key (NFT_SEQ) — LONG — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROFILE_IMAGE)
- Key (PROFILE_IMAGE_ID) — LONG — 기본 키 — NOT NULL
- Key (MEMBER_SEQ) — LONG — 외래 키 → Untitled.Key — NOT NULL
- Field (PROFILE_IMAGE_NAME) — VARCHAR(255)
- Field (PROFILE_IMAGE_SIZE) — LONG
- Field (PROFILE_IMAGE_URL) — VARCHAR(255)
- Field (REG_DT) — TIMESTAMP
Untitled (EXHIBITION)
- Key (EXHIBITION_ID) — LONG — 기본 키 — NOT NULL
- Key (MEMBER_SEQ) — LONG — 외래 키 → Untitled.Key — NOT NULL
- Key (EXHIBITION_TITLE) — VARCHAR(255) — NOT NULL
- Field (EXHIBITION_TYPE) — CHAR(3)
- Field (EXHIBITION_DESCRIPTION) — VARCHAR(255)
- Field (REG_DT) — TIMESTAMP