블록체인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