스터디카페 키오스크 프로젝트
테이블 (13)
coupon (Untitled4)
- coupon_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- item_id (Key32) — Long — 외래 키 → orders.item_id — NOT NULL
- coupon_name (Field4) — String
- start_datetime (Field2) — LocalDateTime
- end_datetime (Field3) — LocalDateTime
- issue_datetime (Field) — LocalDateTime
item (Untitled3)
- item_id (Key) — Long — 기본 키 — NOT NULL
- item_type (Field3) — ItemType
- item_name (Field) — String
- price (Field2) — int
member (Untitled)
- member_id (Key) — Long — 기본 키 — NOT NULL
- member_name (Field) — String
- phone (Field2) — String
- password (Field4) — String
- birth (Field3) — LocalDate
- member_grade (Field5) — MemberGrade
orders (Untitled2)
- order_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- item_id (Key3) — Long — 외래 키 → item.item_id — NOT NULL
- price (Field4) — int
- coupon_id (Field5) — Long
- order_datetime (Field3) — LocalDateTime
- order_status (Field2) — OrderStatus
post (Untitled8)
- post_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- content (Field) — String
- postDateTime (Field2) — LocalDateTime
- check (Field3) — boolean
reservation (Untitled13)
- reservation_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- seat_id (Key3) — Long — 외래 키 → seat.seat_id — NOT NULL
- reservation_datetime (Field) — LocalDateTime
- used (Field2) — boolean
- finished (Field3) — boolean
scheduled_task (Untitled9)
- task_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- execution_time (Field2) — LocalDateTime
- task_type (Field3) — TaskType
seat (Untitled5)
- seat_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- seat_type (Field) — SeatType
- remaining_time (Field2) — LocalTime
subscription (Untitled6)
- subscription_id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
- start_datetime (Field2) — LocalDateTime
- end_datetime (Field3) — LocalDateTime
- left_time (Field4) — Duration
- is_valid (Field) — boolean
usage_status (Untitled7)
- usage_status_id (Key) — Long — 기본 키 — NOT NULL
- subscription_id (Key2) — Long — 외래 키 → subscription.subscription_id — NOT NULL
- member_id (Key22) — Long — 외래 키 → subscription.member_id — NOT NULL
- user_inout (Field) — UserInOut
- usageDateTime (Field2) — LocalDateTime
vote (Untitled12)
- vote_id (Key) — Long — 기본 키 — NOT NULL
- vote_title_id (Key4) — Long — 외래 키 → vote_title.vote_title_id — NOT NULL
- vote_option_id (Key3) — Long — 외래 키 → vote_option.vote_option_id — NOT NULL
- member_id (Key2) — Long — 외래 키 → member.member_id — NOT NULL
vote_option (Untitled11)
- vote_option_id (Key) — Long — 기본 키 — NOT NULL
- vote_title_id (Key2) — Long — 외래 키 → vote_title.vote_title_id — NOT NULL
- content (Field2) — String
vote_title (Untitled10)
- vote_title_id (Key) — Long — 기본 키 — NOT NULL
- title (Field) — String
- is_multiiple (Field2) — boolean
- create_datetime (Field3) — LocalDateTtime