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