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