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)