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