요치캠퍼스

테이블 (8)

ads

  • id — INT
  • company_name — VARCHAR(100) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(255)
  • target_url — VARCHAR(255

categories

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

colleges

  • id — INT
  • college_name — VARCHAR(100) — NOT NULL
  • college_shortname — VARCHAR(30) — NOT NULL
  • email_domain — VARCHAR(100) — NOT NULL
  • term_format — VARCHAR(10) — NOT NULL

email_verifications

  • id — INT
  • user_id — INT — NOT NULL
  • verification_code — CHAR(6)
  • is_verified — BOOLEAN
  • sent_count — TINYINT
  • created_at — TIMESTAMP
  • last_sent_at — TIMESTAMP
  • expires_at — DATETIME

events

  • id — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(255)
  • event_date — DATETIME
  • location — VARCHAR(150)
  • created_by — VARCHAR(100)
  • approved_by_admin — BOOLEAN
  • target_college_id — INT
  • created_at — TIMESTAMP

messages

  • id — INT
  • sender_id — INT
  • receiver_id — INT
  • message — TEXT — NOT NULL
  • sent_at — TIMESTAMP

users

  • id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • major — VARCHAR(60)
  • classof — INT
  • college_id — INT
  • name — VARCHAR(100)

versions

  • id — INT
  • version — VARCHAR(10)
  • content — TEXT
  • is_active — BOOLEAN