DeSSaCManageProgram

Tables (15)

EducationRequest (Untitled5)

  • id — Primary key — NOT NULL
  • source_id — BIGINT — Foreign key → application_source.id — NOT NULL
  • school_id (Key2) — Foreign key → school.id — NOT NULL

User (user)

  • id — BIGINT — Primary key — NOT NULL
  • name
  • birth
  • phone
  • created_at
  • updated_at
  • application_source_id (id2) — BIGINT — Foreign key → application_source.id — NOT NULL

address (Untitled4)

  • id — Primary key — NOT NULL
  • sido
  • detail
  • created_at
  • updated_at

application_profile (Untitled6)

  • id (Key) — Primary key — NOT NULL

application_source (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • source_type
  • name
  • created_at

kit (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

permission

  • id — Primary key — NOT NULL
  • name
  • discription

program (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • link (Field3)
  • lms_id (Field2)
  • social_con_type (Field4)

program_kit_rule (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • program_id (Key2) — Foreign key → program.id — NOT NULL
  • kit_id (Key3) — Foreign key → kit.id — NOT NULL
  • cnt_per_student (Field)

role

  • id — Primary key — NOT NULL
  • name

role_permission (Untitled)

  • role_id — Foreign key → role.id — NOT NULL
  • permission_id — Foreign key → permission.id — NOT NULL

school (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • address_id (id) — Foreign key → address.id — NOT NULL
  • name
  • social_con_type

stock (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • kit_id (Key2) — Foreign key → kit.id — NOT NULL
  • cnt (Field)
  • status (Field4)
  • created_at (Field2)
  • updated_at (Field3)

stock_history (Untitled11)

  • id (Key2) — Primary key — NOT NULL
  • stock)id (Key) — Foreign key → stock.id — NOT NULL
  • cnt (Field)
  • status (Field2)
  • created_at (Field3)

user_role

  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • role_id — Foreign key → role.id — NOT NULL