opensw

Tables (7)

Auction (경매)

  • id — int — Primary key — NOT NULL
  • picture_id — int — Foreign key → Picture.id — NOT NULL
  • start_at — DATETIME — NOT NULL
  • start_price — string — NOT NULL
  • ing_price — string — NOT NULL

Follow (팔로우)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • author_id — int — Foreign key → User.id — NOT NULL

Like (좋아요)

  • id — int — Primary key — NOT NULL
  • picture_id — int — Foreign key → Picture.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL

Mapping (Untitled)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • auction_id — int — Foreign key → Auction.id — NOT NULL

Picture (작품)

  • id — int — Primary key — NOT NULL
  • author_id — int — Foreign key → User.id — NOT NULL
  • name — string — NOT NULL
  • description — string — NOT NULL
  • ingredient — string
  • size_height — string
  • size_width — string
  • make_time — string
  • condition — string
  • is_photo — boolean — NOT NULL
  • create_at — datetime — NOT NULL

PictureImage (이미지URL)

  • id — int — Primary key — NOT NULL
  • picture_id — int — Foreign key → Picture.id — NOT NULL
  • url — string — NOT NULL

User (사용자)

  • id — int — Primary key — NOT NULL
  • user_login_id — string — NOT NULL
  • user_login_password — string — NOT NULL
  • user_email — string — NOT NULL
  • is_author — boolean — NOT NULL
  • user_image — string
  • user_name — string — NOT NULL