artion

Tables (12)

Art

  • Art_pk — Integer — Primary key — NOT NULL
  • User_pk — number — Foreign key → User.User_pk — NOT NULL
  • MinP (minP) — Long
  • MaxP — Long
  • Info — String
  • width — Integer
  • depth — Integer
  • length — Integer
  • Qurater — boolean
  • Created — LocalDate
  • StartTime — LocalDateTime
  • EndTime — LocalDateTime
  • Current_Auction_Status — Integer
  • Art_name — String
  • Painter — String
  • Upload — LocalDate

ArtCategory

  • Category_pk — Integer — Primary key — NOT NULL
  • ArtCategory — String

ArtImage

  • ArtImage_pk — Integer — Primary key — NOT NULL
  • Art_pk — Integer — Foreign key → Art.Art_pk — NOT NULL
  • image — String — 123

Artfollowing (CopyOfArt)

  • Artfollowing_pk — Integer — Primary key — NOT NULL
  • User_pk — Integer — Foreign key → User.User_pk — NOT NULL
  • Art_pk — Integer — Foreign key → Art.Art_pk — NOT NULL

Auction (Aution)

  • Auction_pk — Integer — Primary key — NOT NULL
  • Art_pk — Integer — Foreign key → Art.Art_pk — NOT NULL
  • User_pk (User_pk2) — Integer — Foreign key → User.User_pk — NOT NULL
  • Current_price — Long — 123

BlackList

  • BlackList_pk — Integer — Primary key — NOT NULL
  • Art_pk — Integer — Foreign key → Art.Art_pk — NOT NULL
  • User_pk (User_pk2) — Integer — Foreign key → User.User_pk — NOT NULL

Order

  • Order_pk — Integer — Primary key — NOT NULL
  • Paying_pk — Integer — Foreign key → Paying.Paying_pk — NOT NULL
  • Address_order — String
  • delivery_type — String
  • merchant_uid — String
  • imp_uid — String
  • phone_number — String
  • name — String

Paying

  • Paying_pk — Integer — Primary key — NOT NULL
  • Auction_pk — Integer — Foreign key → Auction.Auction_pk — NOT NULL
  • CreateAt — LocalDateTime — 123
  • status — Integer

User

  • User_pk — Integer — Primary key — NOT NULL
  • User_name — String — 123
  • Address — String
  • Phone_num — String
  • User_Cash — Long
  • BlackListStatus — Boolean
  • User_Account — String
  • Bankname — String
  • kakao_pk — String

User_following

  • User_following_pk — Integer — Primary key — NOT NULL

art_artcategory

  • art_artcategory_pk — Integer — Primary key — NOT NULL
  • Art_pk — Integer — Foreign key → Art.Art_pk — NOT NULL
  • Category_pk (Category_pk2) — Integer — Foreign key → ArtCategory.Category_pk — NOT NULL

following (CopyOfOrder)

  • following_pk — Integer — Primary key — NOT NULL
  • User_following_pk — Integer — Foreign key → User_following.User_following_pk — NOT NULL
  • User_pk — Integer — Foreign key → User.User_pk — NOT NULL