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