supercar

Tables (13)

AttachmentFileList (첨부파일)

  • id (Key2) — Primary key — NOT NULL
  • productId (Key) — long — Foreign key → Product.id — NOT NULL
  • original_file_name (Field2) — String
  • stored_file_path (Field3) — String
  • file_size (Field4) — Long

BoardCategoryL1 (Untitled)

  • id (Key) — Primary key — NOT NULL
  • categoryName (Field)

BoardCategoryL2 (CopyOfUntitled)

  • id (Key2) — Foreign key → BoardCategoryL1.id — NOT NULL
  • postId (Key) — Post — Foreign key → Post.id — NOT NULL
  • categoryName (Field)
  • boardCatgoryL1Id (Field2) — BoardCategoryL1

CarCategory (차량카테고리)

  • carCategory (Key) — CarCategory — Primary key — NOT NULL

Comment (댓글)

  • id (Key2) — Primary key — NOT NULL
  • userId (Key) — User — Foreign key → User.id — NOT NULL
  • content (Field) — String
  • likeCount (Field2) — int
  • createdDate (Field3) — DateTime
  • id (Key22) — Foreign key → Comment.id — NOT NULL

Dealer (딜러)

  • id (Key) — Long — Primary key — NOT NULL
  • dealerId (Field) — Long
  • email (Field2) — String
  • password (Field3) — String
  • phoneNumber (Field4) — String
  • address (Field5) — String
  • role (Field6) — ENUM

Post (게시글)

  • id (Key) — Primary key — NOT NULL
  • userId (Key3) — User — Foreign key → User.id — NOT NULL
  • title (Field5) — String
  • content (Field4) — String
  • createdAt (Field6) — DateTime
  • modifiedAt (Field7) — DateTime
  • viewCount (Field2) — int
  • hitCount (Field3) — int

Product (제품)

  • id (Key) — long — Primary key — NOT NULL
  • dealerId (Key2) — Long — Foreign key → Dealer.id — NOT NULL
  • title (Field3) — String
  • contents (Field4) — String
  • performanceUrl (Field5) — Enum
  • insuranceUrl (Field6) — Enum
  • attachmentFileList (Field7) — List<AttachmentFile>
  • productPicturesList (Field8) — List<ProductPicture>
  • carCategory (Key4) — CarCategory — Foreign key → CarCategory.carCategory — NOT NULL

ProductPicture (제품사진)

  • id (Key) — Long — Primary key — NOT NULL
  • productId (Key2) — long — Foreign key → Product.id — NOT NULL
  • original_file_name (Field2) — String
  • stored_file_path (Field3) — String
  • file_size (Field4) — Long

User (유저)

  • id (Key) — Primary key — NOT NULL
  • userId (long) — long
  • nickname (Field) — String
  • password (Field2) — String
  • name (Field3) — String
  • email (Field4) — String
  • phoneNumber (Field5) — String
  • userRatingEnum (Field6) — Enum
  • registrationDate (Field8) — String

advertisement (광고)

  • Key — Primary key — NOT NULL
  • Field

inquiry (문의)

  • id (Key) — Primary key — NOT NULL
  • inquiryTitle (Field) — String
  • inquiryContent (Field2)
  • name (Field3) — String
  • Field4 — String

paparazzi (파파라치)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Key3) — long — Foreign key → User.id — NOT NULL
  • postId (Key4) — long — Foreign key → Post.id — NOT NULL
  • productId (Key5) — long — Foreign key → Product.id — NOT NULL