budget

Tables (3)

tb_invited_user

  • seq — bigint — Primary key — NOT NULL
  • user_sn — bigint — Foreign key → tb_user_mng.user_sn — NOT NULL
  • project_sn — bigint — Foreign key → tb_project_mng.project_sn — NOT NULL

tb_project_mng

  • project_sn — bigint — Primary key — NOT NULL
  • project_name — nvarchar(60)
  • owner_id — bigint
  • color — nvarchar(50)
  • icon — nvarchar(50)
  • reg_date — datetime
  • reg_user_id — bigint
  • reg_user_name — nvarchar(100)
  • mod_date — datetime
  • mod_user_id — bigint
  • guest_can_edit — nvarchar(1)

tb_user_mng

  • user_sn — bigint — Primary key — NOT NULL
  • user_id — nvarchar(60)
  • user_name — nvarchar(100)
  • last_login_date — datetime
  • password — nvarchar(60)
  • password_enc — nvarchar(200)
  • reg_date — datetime
  • reg_user_id — bigint
  • reg_user_name — nvarchar(100)
  • mod_date — datetime
  • mod_user_id — bigint
  • is_first — nvarchar(1)