danguen

Tables (6)

File (파일)

  • fileId (Key) — int — Primary key — NOT NULL
  • originalname (파일이름) — varchar
  • url (파일url) — varchar
  • extension (확장자) — varchar

File-Product (Untitled2)

  • fileId (Key) — int — Foreign key → File.fileId — NOT NULL
  • productId (Key2) — int — Foreign key → Product.productId — NOT NULL

File-User (Untitled)

  • fileId (Key) — int — Foreign key → File.fileId — NOT NULL
  • userId — int — Foreign key → User.userId — NOT NULL

Product (상품)

  • productId (Key) — int — Primary key — NOT NULL
  • userId (판매자(올린사람)) — int — Foreign key → User.userId — NOT NULL
  • price (가격) — int
  • charge (추가요금) — int
  • title (제목) — varchar
  • content (소개글) — varchar

Reservation (예약(대여))

  • Key — int — Primary key — NOT NULL
  • userId (신청자) — int — Foreign key → User.userId — NOT NULL
  • productId (상품아이디) — int — Foreign key → Product.productId — NOT NULL
  • startDate (대여시작날짜) — Date
  • finalDate (대여마지막날짜) — Date
  • rentalStatus (대여상태) — enum

User (사용자)

  • userId — int — Primary key — NOT NULL
  • email (이메일) — varchar
  • nickname (닉네임) — varchar
  • name (이름) — varchar
  • gender (성별) — enum
  • thumbnailUrl (썸네일이미지) — varchar
  • role (유저상태(호스트/게스트)) — enum
  • userIntro (유저소개글) — varchar
  • accountID (Field)