원광대_체육시설예약시스템

테이블 (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