/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
LANE = db.TABLE("LANE")
LANE_C_ID = LANE.KEY("ID")
LANE_C_VERSION = LANE.VERSION("VERSION")
// Audit
LANE_C_CREATION = LANE.COLUMN("CREATION")
LANE_C_MODIFICATION = LANE.COLUMN("MODIFICATION")
LANE_C_USER_CREATION = LANE.COLUMN("USER_CREATION").As("UserCreationId")
LANE_C_USER_MODIFICATION = LANE.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
LANE_C_NAME = LANE.COLUMN("NAME")
LANE_C_POSITION = LANE.COLUMN("POSITION")
LANE_C_BOARD_ID = LANE.COLUMN("BOARD").As("BoardId")
//FK's
LANE_A_BOARD = LANE.
ASSOCIATE(LANE_C_BOARD_ID).TO(BOARD_C_ID).
As("Board")
LANE_A_TASKS = LANE.
ASSOCIATE(LANE_C_ID).TO(TASK_C_LANE_ID).
/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
ROLE = db.TABLE("ROLE")
ROLE_C_ID = ROLE.KEY("ID")
ROLE_C_VERSION = ROLE.VERSION("VERSION")
// Audit
ROLE_C_CREATION = ROLE.COLUMN("CREATION")
ROLE_C_MODIFICATION = ROLE.COLUMN("MODIFICATION")
ROLE_C_USER_CREATION = ROLE.COLUMN("USER_CREATION").As("UserCreationId")
ROLE_C_USER_MODIFICATION = ROLE.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
ROLE_C_KIND = ROLE.COLUMN("KIND")
ROLE_C_USER_ID = ROLE.COLUMN("USER").As("UserId")
//FK's
ROLE_A_USER = ROLE.
ASSOCIATE(ROLE_C_USER_ID).TO(USER_C_ID).
As("User")
ROLE_A_USER_CREATION = ROLE.ASSOCIATE(ROLE_C_USER_CREATION).TO(USER_C_ID).As("UserCreation")
ROLE_A_USER_MODIFICATION = ROLE.ASSOCIATE(ROLE_C_USER_MODIFICATION).TO(USER_C_ID).As("UserModification")
)
/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
TASK = db.TABLE("TASK")
TASK_C_ID = TASK.KEY("ID")
TASK_C_VERSION = TASK.VERSION("VERSION")
// Audit
TASK_C_CREATION = TASK.COLUMN("CREATION")
TASK_C_MODIFICATION = TASK.COLUMN("MODIFICATION")
TASK_C_USER_CREATION = TASK.COLUMN("USER_CREATION").As("UserCreationId")
TASK_C_USER_MODIFICATION = TASK.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
TASK_C_TITLE = TASK.COLUMN("TITLE")
TASK_C_DETAIL = TASK.COLUMN("DETAIL")
TASK_C_HEAD_COLOR = TASK.COLUMN("HEAD_COLOR")
TASK_C_BODY_COLOR = TASK.COLUMN("BODY_COLOR")
TASK_C_POSITION = TASK.COLUMN("POSITION")
TASK_C_REFERENCE = TASK.COLUMN("REFERENCE")
TASK_C_SPENT = TASK.COLUMN("SPENT")
TASK_C_REMAINING = TASK.COLUMN("REMAINING")
// who is with this task
/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
USER = db.TABLE("USER")
USER_C_ID = USER.KEY("ID")
USER_C_VERSION = USER.VERSION("VERSION")
// Audit
USER_C_CREATION = USER.COLUMN("CREATION")
USER_C_MODIFICATION = USER.COLUMN("MODIFICATION")
USER_C_USER_CREATION = USER.COLUMN("USER_CREATION").As("UserCreationId")
USER_C_USER_MODIFICATION = USER.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
USER_C_NAME = USER.COLUMN("NAME")
USER_C_USERNAME = USER.COLUMN("USERNAME")
USER_C_PASSWORD = USER.COLUMN("PASSWORD")
//FK's
// many to many
USER_A_BOARDS = db.NewM2MAssociation(
"boards",
db.ASSOCIATE(USER_C_ID).WITH(BOARD_USER_C_USERS_ID),
db.ASSOCIATE(BOARD_USER_C_BOARDS_ID).WITH(BOARD_C_ID),
/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
BOARD = db.TABLE("BOARD")
BOARD_C_ID = BOARD.KEY("ID")
BOARD_C_VERSION = BOARD.VERSION("VERSION")
// Audit
BOARD_C_CREATION = BOARD.COLUMN("CREATION")
BOARD_C_MODIFICATION = BOARD.COLUMN("MODIFICATION")
BOARD_C_USER_CREATION = BOARD.COLUMN("USER_CREATION").As("UserCreationId")
BOARD_C_USER_MODIFICATION = BOARD.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
BOARD_C_NAME = BOARD.COLUMN("NAME")
BOARD_C_DESCRIPTION = BOARD.COLUMN("DESCRIPTION")
//FK's
BOARD_A_LANES = BOARD.
ASSOCIATE(BOARD_C_ID).TO(LANE_C_BOARD_ID).
As("Lanes")
// intermediary table
BOARD_USER = db.TABLE("USERS").As("Users")
/**
* Warning: Generated code! do not change!
* Generated by: go/EntityDB.ftl
*/
package tables
import (
"github.com/quintans/goSQL/db"
"github.com/quintans/taskboard/go/entity"
. "github.com/quintans/toolkit/ext"
)
var (
NOTIFICATION = db.TABLE("NOTIFICATION")
NOTIFICATION_C_ID = NOTIFICATION.KEY("ID")
NOTIFICATION_C_VERSION = NOTIFICATION.VERSION("VERSION")
// Audit
NOTIFICATION_C_CREATION = NOTIFICATION.COLUMN("CREATION")
NOTIFICATION_C_MODIFICATION = NOTIFICATION.COLUMN("MODIFICATION")
NOTIFICATION_C_USER_CREATION = NOTIFICATION.COLUMN("USER_CREATION").As("UserCreationId")
NOTIFICATION_C_USER_MODIFICATION = NOTIFICATION.COLUMN("USER_MODIFICATION").As("UserModificationId")
// Atributos
NOTIFICATION_C_EMAIL = NOTIFICATION.COLUMN("EMAIL")
NOTIFICATION_C_TASK_ID = NOTIFICATION.COLUMN("TASK").As("TaskId")
NOTIFICATION_C_LANE_ID = NOTIFICATION.COLUMN("LANE").As("LaneId")
//FK's
NOTIFICATION_A_TASK = NOTIFICATION.
ASSOCIATE(NOTIFICATION_C_TASK_ID).TO(TASK_C_ID).
As("Task")
NOTIFICATION_A_LANE = NOTIFICATION.
ASSOCIATE(NOTIFICATION_C_LANE_ID).TO(LANE_C_ID).