jpmp
Tables (6)
image (Untitled2)
- image_id (Key) — AI, NOT NULL — Primary key — NOT NULL
- nft_id (Key2) — AI, NOT NULL — Foreign key → nft.nft_id — NOT NULL
- image_src (Field) — Not Null
- Field2
interest (관심)
- user_no (Key) — AI — Foreign key → user.user_no — NOT NULL
- nft_id (Key2) — AI, Not Null, Unique — Foreign key → nft.nft_id — NOT NULL
nft (아이템)
- nft_id (Key) — AI, NOT NULL — Primary key — NOT NULL
- nft_name (Field) — Not Null
- nft_description (Field2) — Not Null
- created (Field3) — Not Null
- updated (Field4) — Not Null
- status (Field5) — Not Null
- auther_name (Field6) — Not Null
- owner_address (Field7) — Not Null
- on_sale_yn (Field8) — Not Null
nft_count (Untitled3)
- nft_count_id (Key2) — Not Null — Primary key — NOT NULL
- nft_id (Key) — Foreign key → nft.nft_id — NOT NULL
- max_count (Field) — Not Null
- count (Field2) — Not Null
sale_contract (Untitled)
- sale_id (Key3) — AI, NOT NULL — Primary key — NOT NULL
- user_no (Key) — Foreign key → user.user_no — NOT NULL
- nft_id (Key2) — Foreign key → nft.nft_id — NOT NULL
- start_date (Field) — Not Null
- end_date (Field2) — Not Null
- owner_id (Field3) — Not Null
user (유저)
- user_no (Key) — AI, NOT NULL — Primary key — NOT NULL
- id (Field) — Not Null, Unique
- password (Field2) — Not Null
- name (Field3) — Not Null
- nickname (Field4) — Not Null, Unique
- role (Field5) — Not Null
- walletAddress (Field6) — null, Uinque
- phone (Field7)
- address (Field8)
- address2 (Field9)
- zip (Field10)
- link (Field11)