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