28 lines
1.3 KiB
Python
28 lines
1.3 KiB
Python
from sqlalchemy import Column, Integer, String, Boolean, DateTime
|
|
from datetime import datetime
|
|
from app.core.database import Base
|
|
|
|
class GrpMenuAccess(Base):
|
|
__tablename__ = "grp_menu_access"
|
|
|
|
id = Column(Integer, primary_key=True, index=True, autoincrement=True)
|
|
menu_id = Column(Integer, default=0, index=True) # 0 represents root menu
|
|
menu_item_id = Column(Integer, default=1, index=True)
|
|
menu_item_desc = Column(String(255), nullable=True)
|
|
module_name = Column(String(255), nullable=True)
|
|
main_menu_action_name = Column(String(255), nullable=True) # Angular route path, e.g. /cns-portal/azzu
|
|
main_menu_icon_name = Column(String(255), nullable=True) # Icon name, e.g. vm-bug or cog
|
|
item_seq = Column(Integer, default=1)
|
|
status = Column(String(50), default="A")
|
|
role = Column(String(100), default="Admin")
|
|
usr_grp = Column(Integer, default=1)
|
|
m_create = Column(String(50), default="Y")
|
|
m_edit = Column(String(50), default="Y")
|
|
m_query = Column(String(50), default="Y")
|
|
m_delete = Column(String(50), default="Y")
|
|
m_export = Column(String(50), default="Y")
|
|
m_visible = Column(String(50), default="Y")
|
|
is_disable = Column(String(50), default="N")
|
|
created_at = Column(DateTime, default=datetime.utcnow)
|
|
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|