ilingsam

Tables (8)

club

  • id — INT — Primary key
  • name — VARCHAR(100)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • create_at — VARCHAR(30)
  • updated_at — VARCHAR(30)

club_member

  • id (id2) — INT — Foreign key → member.id
  • id (id3) — INT — Foreign key → club.id

club_sport

  • id (id2) — INT — Foreign key → club.id
  • club_id — INT
  • sport_name — VARCHAR(50)

detail_address

  • Key — Primary key — NOT NULL
  • ID — INT — Foreign key → school_facility.ID — NOT NULL
  • address_id — INT
  • school_id — INT — NOT NULL
  • sido — VARCHAR(50)
  • sigungu — VARCHAR(50)
  • eupmyeon — VARCHAR(50)
  • road_name — VARCHAR(100)
  • building_no — VARCHAR(20)
  • detail — VARCHAR(100)

member

  • id — INT — Primary key
  • username — VARCHAR(50)
  • password — VARCHAR(100)
  • name — VARCHAR(50)
  • gender — VARCHAR(20)
  • birthdate — VARCHAR(30)
  • status — VARCHAR(20)
  • vaildate — VARCHAR(30)
  • create_at — VARCHAR(30)
  • updated_at — VARCHAR(30)

school_club

  • id — INT — Primary key
  • ID — INT — Foreign key → school_facility.ID — NOT NULL
  • id (id2) — INT — Foreign key → club.id
  • sport_type — VARCHAR(50)
  • active_days — VARCHAR(50)
  • active_time — VARCHAR(50)
  • age_range — VARCHAR(50)
  • activity_level — VARCHAR(20)
  • fee — INT
  • description — VARCHAR(255)

school_facility

  • ID — INT — Primary key — NOT NULL
  • BASE_YEAR — INT — NOT NULL
  • ALSFC_CTPRVN_NM — VARCHAR(50) — NOT NULL
  • ALSFC_SIGNGU_NM — VARCHAR(50) — NOT NULL
  • SCHUL_TY_NM — VARCHAR(30) — NOT NULL
  • SCHUL_NM — VARCHAR(120) — NOT NULL
  • OPN_PD — VARCHAR(32) — NOT NULL
  • ARBY_COT_CO_VALUE — VARCHAR(100)
  • ALSFC_ADDR — VARCHAR(255) — NOT NULL
  • OPER_ITEM_CN — VARCHAR(255)
  • OPER_TIME_CN — TEXT
  • SHWERRM_CO — INT — NOT NULL
  • TOILET_CO — INT — NOT NULL
  • LOCKERRM_CO — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

school_url_info

  • Key — Primary key — NOT NULL
  • ID — INT — Foreign key → school_facility.ID — NOT NULL
  • school_id — BIGINT
  • school_name — VARCHAR(120) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • school_homepage_url — VARCHAR(255)
  • edu_office_url — VARCHAR(255)
  • local_portal_url — VARCHAR(255)
  • collected_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL