nft-auction
Tables (9)
ART (작품)
- art_no (회원번호) — number — Primary key — NOT NULL — number
- member_id (아이디) — varchar2(20)
- art_name (작품명) — varchar2(20)
- art_price (가격) — number
- art_content (작품내용) — varchar2(200)
- art_show_date (작품노출기간) — varchar2(50)
- art_reply_count (답변순) — number
- art_wish_count (찜순) — number
- art_view_c ount (조회수순) — number
- art_file_name (작품파일명) — varchar2(100)
- member_nickname (회원닉네임) — varchar2(20)
- art_basic_fee (경매시작금) — number
- member_account (회원계정) — varchar2(50)
- art_json_uri (회원데이터주소) — varchar2(150)
- art_token_id (작품토큰아이디) — varchar2(20)
- payment_no (Key) — number — Foreign key → art_payment.payment_no — NOT NULL
- member_no (Key2) — number — Foreign key → member.member_no — NOT NULL
art_payment (Untitled2)
- payment_no (Key) — number — Primary key — NOT NULL
- art_name (Field) — varchar2(20)
- member_id (Field2) — varchar2(20)
- art_price (Field3) — number
- payment_date (Field4) — timestamp(6)
- merchant_uid (Field5) — varchar2(50)
- payment_type (Field6) — varchar2(1)
- art_file_name (Field7) — varchar2(100)
- auction_no (Key2) — number — Foreign key → auction.auction_no — NOT NULL
- refund_no (Key3) — number — Foreign key → refund.refund_no — NOT NULL
art_reply (Untitled3)
- art_reply_no (Key) — number — Primary key — NOT NULL
- art_no (Field) — number
- art_reply_parent_no (Field2) — number
- art_reply_content (Field3) — varchar2(100
- art_reply_date (Field4) — timestamp(6)
- member_id (Field5) — varchar2(20)
- member_nickname (Field6) — varchar2(20)
- art_no (N/A) — number — Foreign key → ART.art_no — NOT NULL — number
auction (Untitled4)
- auction_no (Key) — number — Primary key — NOT NULL
- art_no (Field) — number
- member_id (Field2) — archar2(20)
- auction_money (Field3) — number
- auction_date (Field4) — timestamp(6)
- auction_result (Field5) — varchar2(1)
- art_no (N/A) — number — Foreign key → ART.art_no — NOT NULL — number
member (Untitled5)
- member_no (Key) — number — Primary key — NOT NULL
- member_id (Field) — varchar2(20)
- member_password (Field2) — varchar2(100)
- member_name (Field3) — varchar2(20)
- member_nickname (Field4) — varchar2(20)
- member_phone (Field5) — varchar2(20)
- member_email (Field6) — varchar2(50)
- member_uid (Field7) — varchar2(50)
- member_account (Field8) — varchar2(50)
- qnaboard_no (Key2) — number — Foreign key → qnaboard.qnaboard_no — NOT NULL
qnaboard (Untitled6)
- qnaboard_no (Key) — number — Primary key — NOT NULL
- qnaboard_title (Field) — varchar2(20)
- qnaboard_content (Field2) — varchar2(100)
- member_nickname (Field3) — varchar2(20)
- qnaboard_date (Field4) — timestamp(6)
- qnareply_count (Field5) — number
- member_id (Field6) — varchar2(20)
qnareply (CopyOfUntitled6)
- reply_no (Key) — number — Primary key — NOT NULL
- qnaboard_no (Key2) — number — Foreign key → qnaboard.qnaboard_no — NOT NULL
- qnaboard_no (Field) — number
- reply_parent_no (Field2) — number
- reply_content (Field3) — varchar2(100)
- member_nickname (Field4) — varchar2(20)
- reply_date (Field5) — timestamp(6)
- member_id (Field6) — varchar2(20)
refund (Untitled7)
- refund_no (Key) — number — Primary key — NOT NULL
- member_id (Field) — varchar2(20)
- refund_account (Field2) — varchar2(20)
- refund_money (Field3) — number
wishlist (CopyOfUntitled7)
- wish_no (Key) — number — Primary key — NOT NULL
- member_id (Field) — varchar2(20)
- art_name (Field2) — varchar2(50)
- art_price (Field3) — number
- art_file_name (Field4) — varchar2(100)
- art_no (Field5) — number
- art_no (N/A) — number — Foreign key → ART.art_no — NOT NULL — number