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)