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