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)