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