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