onbition

Tables (5)

owner_history (Untitled9)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • painting_id (Key2) — BIGINT — Foreign key → painting.id — NOT NULL
  • owned_at (Field) — TIMESTAMP

painting (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • painting_img_url (Field) — varchar
  • title (Field2) — varchar
  • description (Field3) — varchar
  • is_sale (Field4) — BIT
  • auction_price (Field5) — BIGINT
  • sale_price (Field6) — BIGINT
  • tags (Field9) — varchar
  • created_at (Field7) — TIMESTAMP
  • updated_at (Field8) — TIMESTAMP
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

payment (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • painting_id (Key2) — BIGINT — Foreign key → painting.id — NOT NULL
  • pay_amount (Field) — BIGINT
  • created_at (Field2) — TIMESTAMP

user

  • id (user_id) — BIGINT — Primary key — NOT NULL
  • user_id — varchar — 유저 회원 id
  • password (Field2) — varchar
  • profile_img (Field8) — varchar
  • name (Field3) — varchar
  • phone (Field) — varchar
  • card_num (Field9) — varchar
  • account_num (Field10) — varchar
  • roles (Field11) — varchar
  • is_deleted (Field7) — BIT
  • created_at (Field4) — TIMESTAMP
  • updated_at (Field5) — TIMESTAMP
  • deleted_at (Field6) — TIMESTAMP

userBalance (CopyOfUntitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • change_balance (Field4) — BIGINT
  • current_balance (Field3) — BIGINT
  • balance_type (Field) — varchar
  • created_at (Field2) — TIMESTAMP