원광대_체육시설예약시스템
테이블 (12)
Untitled (terms)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Field (code) — varchar(20) — NOT NULL — 약관 코드(SERVICE, PRIVACY 등)
- Field2 (version) — INTEGER — NOT NULL — 약관 버전
- Field3 (title) — varchar(200) — NOT NULL — 약관 제목
- Field (content) — TEXT
- Field (is_active) — boolean — NOT NULL — 활성화 여부
- Field (is_required) — boolean — NOT NULL — 필수 동의, 선택 동의
- Field (created_at) — TIMESTAMPTZ
Untitled (facilities)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- Field2 (type) — varchar(20) — NOT NULL — COURT, GROUND
- Field3 (description) — text — 시설 소개
- Field4 (notice) — text
- Field (is_active) — boolean — NOT NULL
- Field (created_at) — TIMESTAMPTZ — NOT NULL
- Field (updated_at) — TIMESTAMPTZ — NOT NULL
Untitled (facility_images)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (facility_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (file_path) — varchar(500) — NOT NULL — 로컬 저장 가정(이미지 경로)
- Field (original_name) — varchar(255) — NOT NULL
- Field2 (sort_order) — integer — NOT NULL — 이미지 노출 순서
- Field (created_at) — TIMESTAMPTZ — NOT NULL
Untitled (user_terms)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Key (terms_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (agreed) — agreed — NOT NULL
- Field2 (agreed_at) — TIMESTAMPTZ — NOT NULL
Untitled (facility_operating)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (facility_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (day_of_week) — varchar(3) — MON,TUE,WED 등
- Field2 (open_time) — time
- Field3 (close_time) — time
Untitled (facility_closures)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (facility_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (closure_date) — date — NOT NULL
- Field2 (reason) — varchar(200)
- Field (created_by) — created_at
Untitled (reservations)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Key (facility_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (reserved_date) — date — NOT NULL
- Field2 (start_time) — time — NOT NULL
- Field (end_time) — time — NOT NULL
- Field3 (head_count) — integer
- Field2 (purpose) — varchar(100)
- Field (phone_number) — varchar(20)
- Field (status) — varchar(10) — NOT NULL
- Field (created_at) — TIMESTAMPTZ — NOT NULL
- Field (updated_at) — TIMESTAMPTZ — NOT NULL
Untitled (user_roles)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (role) — VARCHAR(10) — ADMIN/MANAGER/USER
Untitled (penalties)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Key (reservation_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (reason) — varchar(200)
- Field2 (start_date) — date
- Field (end_date) — date
- Field (created_at) — TIMESTAMPTZ
- Field (status) — varchar(10) — ACTIVE ,EXPIRED,CANCELED
Untitled (notices)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (created_by) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (title) — varchar(200) — NOT NULL
- Field2 (content) — TEXT
- Field (is_pinned) — boolean
- Field (view_count) — integer
- Field
- Field2 (created_at) — TIMESTAMPTZ
- Field3 (modified_at) — TIMESTAMPTZ
Untitled (notice_images)
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Key (notice_id) — BIGSERIAL — 외래 키 → Untitled.Key — NOT NULL
- Field (file_path) — bytea — NOT NULL
- Field (original_name) — varchar(255) — NOT NULL
- Field2 (sort_order) — integer — NOT NULL
- Field (created_at) — TIMESTAMPTZ — NOT NULL
users
- Key (id) — BIGSERIAL — 기본 키 — NOT NULL
- Field (name) — VARCHAR — NOT NULL
- Field2 (email) — VARCHAR — NOT NULL — UNIQUE
- Field3 (provider) — VARCHAR(10) — NOT NULL — NAVER, KAKAO
- Field4 (provider_sid) — VARCHAR(200) — NOT NULL — 소셜측 SID값
- Field (role) — VARCHAR(10) — NOT NULL
- Field2 (status) — varchar(10) — NOT NULL — ACTIVE,BLOCKED/DELETED
- Field (created_at) — TIMESTAMPTZ — NOT NULL — 가입일자
- Field2 (updated_at) — TIMESTAMPTZ — NOT NULL
- Field (last_login_at) — TIMESTAMPTZ
- Field (deleted_at) — TIMESTAMPTZ — soft delete