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