black-company

Tables (5)

attend (유저 참여 정보)

  • user_event_id (식별자) — NOT NULL — Primary key — NOT NULL
  • program_id (프로그램 FK) — NOT NULL — Foreign key → program.program_id — NOT NULL
  • member_id (유저 FK) — NOT NULL — Foreign key → member.member_id — NOT NULL
  • attend_status (참여 상태) — default = related

auth_info (인증 정보)

  • auth_info_id (식별자) — NOT NULL — Primary key — NOT NULL
  • member_id (유저 FK) — NOT NULL — Foreign key → member.member_id — NOT NULL
  • auth_info_token (토큰) — NOT NULL

member (유저)

  • member_id (식별자) — NOT NULL — Primary key — NOT NULL
  • member_name (유저 이름) — NOT NULL
  • member_active_status (활동 상태) — NOT NULL
  • member_login_type (로그인 타입) — NOT NULL

program (프로그램)

  • program_id (식별자) — NOT NULL — Primary key — NOT NULL
  • program_title (제목) — NOT NULL
  • program_deadLine (마감기한) — NOT NULL
  • program_content (내용) — NOT NULL
  • program_category (카테고리) — NOT NULL
  • program_property (특성) — NOT NULL

social_ogin (소셜 로그인 유저)

  • social_login_id (식별자) — NOT NULL — Primary key — NOT NULL
  • member_id (유저 FK) — NOT NULL — Foreign key → member.member_id — NOT NULL
  • oauth_id (oauth에서 유저의 ID) — NOT NULL