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