ClimbingCRM
Tables (5)
Admin (관리자 계정)
- id (Key) — Long — Primary key — NOT NULL
- regionId (Forignkey) — Long — Foreign key → Region.id — NOT NULL
- username (Field) — text
- password (Field2) — Long
- phone (Field3) — Phone
Member (회원데이터 비즈니스 로직용도)
- id (Key) — Long — Primary key — NOT NULL
- active_ticket_id (ForignKey) — Long — Foreign key → Ticket.Key — NOT NULL
- Region_id (Key2) — Long — Foreign key → Region.id — NOT NULL
- username (Field) — text
- available (Field2) — text
- phone (Field3) — Phone
- attendance (Field4) — Long
- last_attendance (Field5) — LocalDate
- start_date (Field6) — LocalDate
- end_date (Field7)
- remain_count (Field8) — int
- created_at (Field9) — LocalDateTime
- updated_at (Field10) — LocalDateTime
- memo (Field11) — text
- emergency_contact (Field12) — text
- birth_date (Field13) — LocalDate
- gender (Field14) — text
Region (지점)
- id (Key) — Long — Primary key — NOT NULL
- type (Field3) — Long
- name (Field) — text
- address (Field2) — text
Registration record (회원 기록)
- id (Key) — Long — Primary key — NOT NULL
- Member_id (ForignKey) — Long — Foreign key → Member.id — NOT NULL
- start_date (Field) — LocalDate
- end_date (Field2) — LocalDate
- ticket_type (Field3) — text
Ticket (이용권)
- Key — Long — Primary key — NOT NULL
- tieket_type (Field) — text
- count (Field4) — int
- duration (Field2) — int
- price (Field3)
- description (Field5) — text