flowering_pjt
Tables (17)
Consultant
- consultant_id (Key) — Long — Primary key — NOT NULL
- review_count — int
Customer
- customer_id (Key) — Long — Primary key — NOT NULL
- 예약 (reservations)
- 컨설팅 (consulting)
FAQ
- faq_id (Key) — Long — Primary key — NOT NULL
- question — varchar(200)
- answer — varchar(200)
Magazine
- Magazine_id (PK) — Long — Primary key — NOT NULL
- admin_id (Field3) — Long — Foreign key → admin.admin_id
- title (Field) — varchar(200)
- contents — varchar(200)
Reservation
- reservation_id — Primary key — NOT NULL
- consultant_id (fk) — Long — Foreign key → Consultant.consultant_id — NOT NULL
- customer_id (Key3) — Long — Foreign key → Customer.customer_id — NOT NULL
- time — time
- request — varchar(200)
- created_date — timestamp
- purpose — Enum
- date — date
User
- id — Long — Primary key — NOT NULL
- role — Enum
- email — varchar(200)
- department — varchar(200)
- name — varchar(200)
- password — varchar(200)
- createAt — LocalDateTime
- provider — AuthProvider
- status — UserStatus
admin
- admin_id (pk) — Long — Primary key
community
- community_id (Key) — Long — Primary key — NOT NULL
- customer_id (Key2) — Long — Foreign key → Customer.customer_id — NOT NULL
- time — time
- date — date
- created_date — timestamp
consultingResult
- consultingResult_id (pk) — Long — Primary key — NOT NULL
- sessionId — varchar(200)
- comment — varchar(200)
- Field
cosulting
- cosulting_id (Key) — Long — Primary key — NOT NULL
- consultant_id (Key2) — Long — Foreign key → Consultant.consultant_id — NOT NULL
- consultingResult_id (Key3) — Long — Foreign key → consultingResult.consultingResult_id — NOT NULL
- customer_id (Key4) — Long — Foreign key → Customer.customer_id — NOT NULL
- created_date — timestamp
- price — Long
customercommunity
- usercommunity_id (Key) — Long — Primary key — NOT NULL
- community_id (Key2) — Long — Foreign key → community.community_id — NOT NULL
- customer_id (Key3) — Long — Foreign key → Customer.customer_id — NOT NULL
mycart
- mycart_id (Key) — Long — Primary key — NOT NULL
- cosulting_id (Key2) — Long — Foreign key → cosulting.cosulting_id — NOT NULL
- consultant_id (Key22) — Long — Foreign key → cosulting.consultant_id — NOT NULL
- consultingResult_id (Key3) — Long — Foreign key → cosulting.consultingResult_id — NOT NULL
- customer_id (Key4) — Long — Foreign key → cosulting.customer_id — NOT NULL
notify
- notify_id (Key) — Long — Primary key — NOT NULL
- admin_id (FK) — Long — Foreign key → admin.admin_id
- title — varchar(200)
- contents — varchar(200)
purpose
- 커뮤니티 (community)
- 컨설팅 (consulting)
survey
- survey_id — Long — Primary key — NOT NULL
- customer_id (Key2) — Long — Foreign key → Customer.customer_id — NOT NULL
- SkinType — enum