bizib
Tables (10)
business_card
- business_card_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- card_idx — BIGINT — NOT NULL
- group_key — CHAR(17)
- uuid — CHAR(32)
- image_path — NVARCHAR(1000)
- group_memo — NVARCHAR(50)
- address — NVARCHAR(300)
- address_detail — NVARCHAR(300)
- company — NVARCHAR(100)
- name — NVARCHAR(50)
- email — NVARCHAR(100)
- normal_phone — NVARCHAR(30)
- fax_phone — NVARCHAR(30)
- mobile_phone — NVARCHAR(30)
- rank — NVARCHAR(15)
- position — NVARCHAR(15)
- part — NVARCHAR(15)
- belong — NVARCHAR(15)
- homepage — NVARCHAR(100)
- etc — NVARCHAR(1000)
- personal_memo — NVARCHAR(1000)
- owner_id — BIGINT — Foreign key → users.user_id
- main_card — BOOLEAN
- is_digital_card — BOOLEAN
- is_use — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
- INDEX — idx_uuid
- INDEX — idx_is_digital_card_main_card
- INDEX — idx_owner_id
business_card_history
- business_card_history_id — BIGINT — Primary key — NOT NULL
- business_card_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- card_idx — BIGINT — NOT NULL
- group_key — CHAR(17)
- uuid — CHAR(32)
- image_path — NVARCHAR(1000)
- group_memo — NVARCHAR(50)
- address — NVARCHAR(300)
- address_detail — NVARCHAR(300)
- company — NVARCHAR(100)
- name — NVARCHAR(50)
- email — NVARCHAR(100)
- normal_phone — NVARCHAR(30)
- fax_phone — NVARCHAR(30)
- mobile_phone — NVARCHAR(30)
- rank — NVARCHAR(15)
- position — NVARCHAR(15)
- part — NVARCHAR(15)
- belong — NVARCHAR(15)
- homepage — NVARCHAR(100)
- etc — NVARCHAR(1000)
- personal_memo — NVARCHAR(1000)
- owner_id — BIGINT
- main_card — BOOLEAN
- is_digital_card — BOOLEAN
- is_use — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
business_card_temp
- business_card_temp_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- group_key — CHAR(17)
- card_idx — BIGINT — NOT NULL
- image_path — NVARCHAR(1000)
- korean_road_address — json
- korean_jibun_address — json
- english_road_address — json
- english_jibun_address — json
- korean_company — json
- english_company — json
- email — json
- korean_normal_phone — json
- korean_fax_phone — json
- korean_mobile_phone — json
- english_mobile_phone — json
- korean_rank — json
- english_rank — json
- korean_part — json
- english_part — json
- korean_belong — json
- english_belong — json
- homepage — json
- korean_name — json
- english_name — json
- etc — json
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
business_card_temp_backup
- business_card_temp_backup_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- card_idx — BIGINT — NOT NULL
- group_key — CHAR(17)
- image_path — NVARCHAR(1000)
- korean_road_address — json
- korean_jibun_address — json
- english_road_address — json
- english_jibun_address — json
- korean_company — json
- english_company — json
- email — json
- korean_normal_phone — json
- korean_fax_phone — json
- korean_mobile_phone — json
- english_mobile_phone — json
- korean_rank — json
- english_rank — json
- korean_part — json
- english_part — json
- korean_belong — json
- english_belong — json
- homepage — json
- korean_name — json
- english_name — json
- etc — json
- is_card — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
- INDEX — idx_user_id_group_key
friends
- friends_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- target_id — BIGINT — Foreign key → users.user_id — NOT NULL
- is_mutual — BOOLEAN
- is_use — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_user_id_target_id
- INDEX — idx_user_id
- INDEX — idx_target_id
profile_detail_info
- profile_detail_key — NVARCHAR(30)
- profile_detail_value — NVARCHAR(30)
- group_name — NVARCHAR(30)
- sort — INT
- is_use — BOOLEAN
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100)
- provider — NVARCHAR(50)
- provider_id — NVARCHAR(200)
- password — VARCHAR(500)
- role — VARCHAR(30)
- is_use — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users_log
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100)
- provider — NVARCHAR(50)
- provider_id — NVARCHAR(200)
- username — NVARCHAR(50)
- password — VARCHAR(500)
- role — VARCHAR(30)
- is_use — BOOLEAN
- created_at — TIMESTAMP
users_profile
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- uuid — CHAR(32)
- user_name — NVARCHAR(30)
- is_sns_user_name — BOOLEAN
- profile_img — NVARCHAR(1000)
- is_sns_profile_img — BOOLEAN
- phone — NVARCHAR(20)
- company — NVARCHAR(30)
- position — NVARCHAR(15)
- part — NVARCHAR(15)
- portfolio — NVARCHAR(1000)
- address — NVARCHAR(15)
- zipcode — NVARCHAR(6)
- profile_open — BOOLEAN
- is_use — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_name_phone
- INDEX — idx_uuid
users_profile_detail
- user_id — BIGINT — Primary key — NOT NULL
- introduction — json
- career — json
- school — json
- job_group — json
- skill — json
- award — json
- language — json
- license — json
- link — json
- military — json
- volunteer — json
- hobby — json
- publishing — json
- lecture — json
- club — json
- curriculum — json
- sort — json
- curriculum_open — BOOLEAN
- is_use — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP