ALittleBid
Tables (7)
Center (서비스 센터)
- centerId (center_id) — Long — Primary key — NOT NULL
- latitude — double
- longitude — double
- name (Field) — String
- memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
Image (사진)
- imageId (image_id) — Long — Primary key — NOT NULL
- link — String
- postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
Member (유저)
- memberId (member_id) — Long — Primary key — NOT NULL
- loginId (login_id) — String
- password — String
- profile — String
Offer (Untitled3)
- offerId (Key) — Long — Primary key — NOT NULL
- price (Field) — int
- contents (Field2) — String
- createdAt (Field3) — LocalDateTime
- updatedAt (Field4) — LocalDateTime
- centerId (center_id) — Long — Foreign key → Center.centerId — NOT NULL
- postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
Post (문의 게시글)
- postId (post_id) — Long — Primary key — NOT NULL
- title — String
- contents — String
- type — String
- model — String
- repair — String
- tuneUp (tune_up) — String
- close — boolean
- createdAt (created_at) — LocalDateTime
- updatedAtu (updated_at) — LocalDateTime
- memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
- regionId (Key) — Long — Foreign key → Region.regionId — NOT NULL
PostPerCenter (Untitled2)
- ppcId (Key) — Long — Primary key — NOT NULL
- postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
- centerId (center_id) — Long — Foreign key → Center.centerId — NOT NULL
Region (Untitled)
- regionId (Key) — Long — Primary key — NOT NULL
- name (Field2) — String