스터디카페 키오스크 프로젝트

테이블 (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