캡스톤_컴공졸업프로젝트

테이블 (10)

Copy Of Untitled (BATTERY_SCHEDULING)

  • Key (BATTERY_SCHEDULING_ID) — bigint — 기본 키 — NOT NULL
  • Field3 (REAL_CONSUMPTION) — double
  • Field4 (REAL_TIMESTAMP) — datetime
  • Field5 (PREDICT_CONSUMPTION) — double
  • Field6 (PREDICT_TIMESTAMP) — datetime
  • Field2 (SOC) — double
  • Field (BATTERY_POWER) — double
  • Field2 (SCEDULE_TIMESTAMP) — datetime
  • Field3 (TOU) — double

Untitled (TOKEN)

  • Key (USER_EMAIL) — varchar(255) — 기본 키 — NOT NULL
  • Field (CREATED_DT) — datetime(6)
  • Field2 (MODIFIED_DT) — datetime(6)
  • Field3 (REFRESH_TOKEN) — varchar(255)

Untitled (GALLERY)

  • Field (GALLERY_ID) — bigint
  • 유저식별자 (MEMBER_ID) — bigint — 외래 키 → 멤버.유저식별자 — NOT NULL
  • Field (FILE_PATH) — text

Untitled (PERSISTENT_LOGINS)

  • Key (SERIES) — varchar(255) — 기본 키 — NOT NULL
  • Field (LAST_USED) — datetime(6)
  • Field2 (TOKEN) — varchar(255)
  • Field3 (USERNAME) — varchar(255)

Untitled (POWER_USAGE)

  • Key (POWER_USAGE_ID) — bigint — 기본 키 — NOT NULL
  • Field (BUILDING) — int
  • Field2 (FLOOR) — int
  • Field3 (REAL_CONSUMPTION) — double
  • Field4 (REAL_TIMESTAMP) — datetime
  • Field5 (PREDICT_ELEC) — double
  • Field6 (PREDICT_TIMESTAMP) — datetime

멤버 (MEMBER)

  • 유저식별자 (MEMBER_ID) — bigint — 기본 키 — NOT NULL
  • (AUTHORITY) — enum
  • Field (EMAIL) — varchar(255)
  • Field2 (PASSWORD) — varchar(255)
  • Field3 (PROVIDER) — enum
  • Field4 (USERNAME) — varchar(255)

채팅메시지 (CHAT_MSG)

  • 채팅메시지식별자 (CHAT_MSG_ID) — bigint — 기본 키 — NOT NULL
  • 채팅방식별자 (CHAT_ROOM_ID) — bigint — 외래 키 → 채팅방.채팅방식별자 — NOT NULL
  • 전송자 (SENDER) — bigint — 외래 키 → 멤버.유저식별자 — NOT NULL
  • 내용 (CONTENT) — text — NOT NULL
  • 전송시각 (SENT_TIME) — timestamp — NOT NULL

채팅방 (CHAT_ROOM)

  • 채팅방식별자 (CHAT_ROOM_ID) — bigint — 기본 키 — NOT NULL
  • 방생성일 (CREATED_TIME) — timestamp — NOT NULL

쿠폰발급이력 (COUPON_HISTORY)

  • 쿠폰발급이력식별자 (COUPON_HISOTY_ID) — bigint — 기본 키 — NOT NULL
  • 쿠폰발급대상 (ISSUANCE_TARGET) — varchar(9) — 외래 키 → 멤버.유저식별자 — NOT NULL — ex) 101_10
  • 쿠폰종류식별자 (COUPON_TYPE_ID) — bigint — 외래 키 → 쿠폰종류.쿠폰종류식별자 — NOT NULL
  • 쿠폰발급일 (ISSUE_DATE) — date — NOT NULL

쿠폰종류 (COUPON_TYPE)

  • 쿠폰종류식별자 (COUPON_TYPE_ID) — bigint — 기본 키 — NOT NULL
  • 종류 (COUPON_TYPE) — varchar(3) — NOT NULL — p5 또는 p10