YRC
Tables (4)
tb_member (회원)
- member_seq (회원번호(카카오)) — number(10) — Primary key — NOT NULL
- member_name (회원이름(카카오)) — varchar2(100)
- member_clss_cd (회원분류코드) — varchar(2)
- start_date (시작일자) — date
- end_date (종료일자) — date
- reg_date (등록일시(카카오)) — datetime
- updt_date (수정일시) — datetime
- reg_id (등록자ID) — varchar2(30)
- updt_id (수정자ID) — varchar2(30)
tb_race_record (레이스기록)
- record_seq (기록번호) — number(10) — Primary key — NOT NULL
- record_date (기록일) — date
- race_clss_cd (종목분류코드) — varchar(2)
- reg_date (등록일시) — datetime
- updt_date (수정일시) — datetime
- reg_id (등록자ID) — varchar2(30)
- updt_id (수정자ID) — varchar2(30)
tb_run_info (러닝정보)
- info_seq (정보시퀀스) — number(10) — Primary key — NOT NULL
- open_date (오픈일) — datetime — Primary key — NOT NULL
- run_clss_cd (러닝분류코드) — varchar(2) — Primary key — NOT NULL
- reg_id (등록자ID) — varchar2(30)
- member_open_yn (오픈여부(정회원)) — varchar(1)
- guest_open_yn (오픈여부(게스트)) — varchar(1)
- reg_date (등록일) — datetime
tp_attend (출석부)
- attend_seq (출석번호) — number(10) — Primary key — NOT NULL
- attend_date (출석일) — date
- run_clss_cd (러닝분류코드) — varchar(2)
- pacer_yn (페이서여부) — varchar(1)
- swipper_yn (스위퍼여부) — varchar(1)
- appr_yn (승인여부) — varchar(1)
- reg_date (등록일시) — datetime
- updt_date (수정일시) — datetime
- reg_id (등록자ID) — varchar2(30)
- updt_id (수정자ID) — varchar2(30)