Ev-Charge

Tables (9)

TB_ADMIN_LOG

  • 기본키 (LOG_ID) — NUMBER — Primary key — NOT NULL
  • ADMIN_EMAIL — VARCHAR2(100) — NOT NULL
  • ACTION — VARCHAR2(100)
  • TARGET — VARCHAR2(100)
  • CREATED_AT — TIMESTAMP

TB_CHARGER

  • CHARGER_ID — NUMBER — Primary key — NOT NULL
  • STATION_ID — NUMBER — Foreign key → TB_STATION.STATION_ID — NOT NULL
  • C_TYPE — VARCHAR2(20)
  • C_STATUS — VARCHAR2(20)

TB_COMMUNITY

  • C_UUID — NUMBER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(100) — Foreign key → TB_MEMBER.EMAIL — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB
  • IS_NOTICE — NUMBER(1)
  • IS_DELETED — CHAR(1)
  • INSERT_TIME — TIMESTAMP
  • UPDATE_TIME — TIMESTAMP

TB_DAILY_STATS

  • 기본키 (STAT_ID) — NUMBER — Primary key — NOT NULL
  • STAT_DATE — DATE — NOT NULL
  • RESERV_COUNT — NUMBER
  • REGIST_COUNT — NUMBER
  • POINT_TOPUP — NUMBER
  • CANCEL_COUNT — NUMBER

TB_MEMBER

  • EMAIL — VARCHAR2(100) — Primary key — NOT NULL
  • PASSWORD — VARCHAR2(100) — NOT NULL
  • MEMBER_CODE — VARCHAR2(100)
  • MEMBER_NAME — VARCHAR2(100)
  • CAR_NUMBER — VARCHAR2(100)
  • PHONE_NUMBER — VARCHAR2(100)
  • ROLE — VARCHAR2(20)
  • IS_DELETED — CHAR(1)
  • INSERT_TIME — TIMESTAMP — NOT NULL
  • UPDATE_TIME — TIMESTAMP — NOT NULL

TB_PAYMENT

  • PAY_ID — NUMBER — Primary key — NOT NULL
  • EMAIL — VARCHAR2(100) — Foreign key → TB_MEMBER.EMAIL — NOT NULL
  • RESERVATION_ID — NUMBER — Foreign key → TB_RESERVATION.RESERVATION_ID
  • PAYMENT_TYPE — VARCHAR2(20)
  • AMOUNT — NUMBER — NOT NULL
  • METHOD — VARCHAR2(50)
  • CREATED_AT — TIMESTAMP

TB_RESERVATION

  • RESERVATION_ID — NUMBER — Primary key — NOT NULL
  • CHARGER_ID — NUMBER — Foreign key → TB_CHARGER.CHARGER_ID — NOT NULL
  • EMAIL — VARCHAR2(100) — Foreign key → TB_MEMBER.EMAIL — NOT NULL
  • START_TIME — TIMESTAMP — NOT NULL
  • END_TIME — TIMESTAMP — NOT NULL
  • STATUS — VARCHAR2(20)

TB_STATION

  • STATION_ID — NUMBER — Primary key — NOT NULL
  • STATION_NAME — VARCHAR2(100) — NOT NULL
  • ADDRESS — VARCHAR2(255)
  • LAT — NUMBER(10, 8) — NOT NULL
  • LNG — NUMBER(11, 8) — NOT NULL
  • IS_DELETED — CHAR(1)

TB_WALLET

  • WALLET_ID — NUMBER — Primary key — NOT NULL
  • POINT — NUMBER
  • EMAIL — VARCHAR2(100) — Foreign key → TB_MEMBER.EMAIL — NOT NULL