S-traffic
Tables (9)
PARKING_SPOT
- spotId — VARCHAR2(10)
- occupied — CHAR(1)
- plateNumber — VARCHAR2(20)
- entryTime — TIMESTAMP
board
- id — NUMBER
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- author_id — VARCHAR2(100) — Foreign key → mem1213.id — NOT NULL
- views — NUMBER
- pinned — CHAR(1)
- imageData — BLOB
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
board_comment
- id — NUMBER
- board_id — NUMBER — Foreign key → board.id — NOT NULL
- author_id — VARCHAR2(100) — Foreign key → mem1213.id — NOT NULL
- content — CLOB — NOT NULL
- pinned — CHAR(1)
- createdAt — TIMESTAMP
ktx_reservation
- id — NUMBER
- memberId — VARCHAR2(100) — Foreign key → mem1213.id
- trainNo — VARCHAR2(50) — NOT NULL
- travelDate — DATE — NOT NULL
- seats — VARCHAR2(100)
- passengerCount — NUMBER — NOT NULL
- totalPrice — NUMBER — NOT NULL
- reservedAt — TIMESTAMP
ktx_train
- id — NUMBER
- trainNo — VARCHAR2(50) — NOT NULL
- departure — VARCHAR2(100) — NOT NULL
- arrival — VARCHAR2(100) — NOT NULL
- departureTime — VARCHAR2(10)
- arrivalTime — VARCHAR2(10)
- price — NUMBER — NOT NULL
- totalSeats — NUMBER — NOT NULL
- travelDate — DATE — NOT NULL
mem1213
- id — VARCHAR2(100)
- pw — VARCHAR2(255) — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- tel — VARCHAR2(20)
- role — VARCHAR2(50)
- provider — VARCHAR2(50)
- providerId — VARCHAR2(255)
- profileImageData — BLOB
- createdAt — TIMESTAMP
notice
- id — NUMBER
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- author_id — VARCHAR2(100) — Foreign key → mem1213.id — NOT NULL
- tag — VARCHAR2(20)
- pinned — CHAR(1)
- views — NUMBER
- imageData — BLOB
- createdAt — TIMESTAMP
page_view_history
- id — NUMBER
- page_name — VARCHAR2(100) — NOT NULL
- viewed_at — TIMESTAMP
parking_record
- id — NUMBER
- parkingSpot — VARCHAR2(10) — Foreign key → PARKING_SPOT.spotId — NOT NULL
- carNumber — VARCHAR2(20) — NOT NULL
- entryTime — TIMESTAMP — NOT NULL
- exitTime — TIMESTAMP
- durationMinutes — NUMBER
- fee — NUMBER