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