요치캠퍼스
테이블 (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