보로미 테이블 설계
테이블 (7)
Category (category)
- id (Key) — bigint — 기본 키 — NOT NULL
- category_name (Field) — varchar(20)
- created_at (Field2) — timestamp
- update_at (Field3) — timestamp
Place (place)
- id (Key) — bigint — 기본 키 — NOT NULL
- place_name (Field) — varchar(20)
- created_at (Field2) — timestamp
- update_at (Field3) — timestamp
Product (product)
- id (Key) — bigint — 기본 키 — NOT NULL
- comp_id (FK) — bigint — 외래 키 → User.id — NOT NULL
- category_id (FK2) — bigint — 외래 키 → Category.id — NOT NULL
- place_id (FK3) — bigint — 외래 키 → Place.id — NOT NULL
- product_name (Field) — varchar(100)
- image (Field2) — varchar(250)
- product_price (Field4) — int
- description (Field5) — varchar(100)
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp
PruductImage (product_images)
- id (Key) — bigint — 기본 키 — NOT NULL
- product_id (FK) — bigint — 외래 키 → Product.id — NOT NULL
- product_url (Field) — varchar(250)
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
Rent (rent)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (FK) — bigint — 외래 키 → User.id — NOT NULL
- comp_id (FK2) — bigint — 외래 키 → User.id — NOT NULL
- product_id (FK3) — bigint — 외래 키 → Product.id — NOT NULL
- start_date (Field) — timestamp
- end_date (Field2) — timestamp
- period (Field3) — timestamp
- rent_price (Field4) — int
- status (Field5) — varchar(20)
Review (review)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (FK) — bigint — 외래 키 → User.id — NOT NULL
- comp_id (FK2) — bigint — 외래 키 → User.id — NOT NULL
- product_id (FK3) — bigint — 외래 키 → Product.id — NOT NULL
- rating (Field) — double
- content (Field2) — varchar(20)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
User (user)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_name (Field) — varchar(20)
- profile_url (Field2) — varchar(250)
- university (Field3) — varchar(20)
- roles (Field4) — varchar(20)
- point (Field5) — int
- introduction (Field6) — varchar(20)
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp